Hi all,

I'm using SQLite with NHibernate, and am having performance problems when peforming a lot of inserts/deletes.

I've got a nested object hierarchy, which results in a lot of records to be inserted/deleted when objects are created/deleted. When I save to the database, system performance is not good, with a lot of disk activity.

Are there any cacheing/extent settings for SQLite which I can set via the NHibernate dialect interface?

Thanks,

James

Found the problem.

I was not wrapping the save in a transaction. Doing so has increased performance hugely. Presumably the behaviour of either the dialect implementation, or of SQLite itself, is to wrap each individual insert in a transaction if there is no transaction already open.

James