Howdy y'all, I am facing the following scenario: For a rule engine once a day a larger number (100.000+) of data sets will be recalculated and saved in a MS SQL database via NHibernate in order to be able to answer rule questions quickly. Now my problem is that the system has to be able to answer the questions without interruptions 24/7. Because saving all those data sets to the database is going to take a while I cannot just clear the table and start writing. One solution I thought of was using two tables: One table contains the active rules. The other table is empty. Now when I recalculate the rules I will write them to the empty table. As soon as this is done I switch the active table. Then I clear the old rules from table # one. The next day the procedure repeats in the other direction. The table mappings in NHibernate are static though and so I do not see a way how to do this. Variation number two would be to add a version coloumn to the data sets and filter by the version number. But where would I store the information what the _current_ version for reading is? Any ideas how to implement the two solutions mentioned above or any other ideas how to solve my problem will be appreciated!
Best regards, void* -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
