I have an existing web service application built using .NET 2 and NHibernate 3.3 that is linked to a SQLServer 2005 database. The application does a sequence of queries into the database at start up and these complete in about 3 seconds using my test database. I recently set up a MySQL server and changed the config to us that (without any change to the code), migrated the database to MySQL 5 and it works fine with a similar load time. I have now added v1.0.66.0 of System.Data.SQLite.dll to the bin directory, migrated the database to SQLite v3 changed the config and run that. This successfully loads the data but it takes nearly 10 minutes to load! The database size is <3Mb, so something is obviously seriously wrong.
I enabled DEBUG level logging on the NHibernate.SQL logger and proved that the SQL being issued was pretty nearly identical. When the data is loaded from the SQLite database the CPU maxes out completely at 100%, like it is running huge numbers of loops. Has anyone ever seen this sort of behaviour before? If not, any idea how I can diagnose what is wrong? Setting general DEBUG level in log4net produces so much output and slows things down so much it never ends, so I would rather not do that! -- 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/-/rtO7OX7ZwecJ. 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.
