Could it be that the sqlite ado.net provider has bad performance on large result sets? Maybe a look in that code is interesting. I presume the sqlite tools you used use sqlite natively and not through ado.net?
/Oskar 2012/12/5 tonka.taylor <[email protected]>: > I have also checked that the cartesian set returned by SQLServer (in the > Microsoft GUI) and that returned by SQLite (in SQLiteSpy) are the same size > (about 30k rows for the SQL query I looked at) and appear to be identical as > far as I can tell. > > The timings above suggest that there is some problem with executing the > query on the database but that there is a massive problem in processing the > data once it has been received into NHibernate. I am just at a loss to know > what could be causing it. > > Anyone any ideas? > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/nhusers/-/nxowPxX2RWkJ. > > 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. -- 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.
