Hello, I've got an NHibernate performance optimization question. I believe what I am seeing has to do with SaveOrUpdate() latency, but I'm not 100% sure of it.
What's going on is this: I've got a data service which job it is to factory create a bunch of data for test and/or production environments. I do this an IList<> at a time and SaveOrUpdate() that enumeration of data in one transaction. What I am seeing is that my service count of processed data items keeps on increasing, which is good. That's what I want to have happen. However, what is not so good is that my backend database (MySQL) count is not increasing nearly as quickly. So I'm thinking there is some latency between SaveOrUpdate() and when the record(s) actually hit the database. So... My question is this, I don't want to slow down the service more than is necessary, but I believe it would be helpful for the service not to get so far ahead of the database. So... Can I do a Session Flush? Or other type operation along these lines? Another thing might be to abandon Sessions altogether and go direct through a Sql DbCommand, for that matter. Thoughts? Best regards, Michael -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" 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/fluent-nhibernate?hl=en.
