Access on NHibernate: slowness ?

Question

Hi,

I'm using NHibernate and Microsoft Access. My database file is fairly large ( ~500 MB ) and my app. is slow when writing to the database and I was wondering if any of you have experience with NHibernate and large Access databases. I want to know if this slowness in the app. is an known issue.

Regards, MadSeb

P.S I did "compact and repair" the database.

Answer 1

Post comment update
You are not seeing 'normal slowness', you are seeing long hangs. I would need to see code / config / database schema / database stats (#of rows in tables, indexes etc) to help any.

P.S.
500 MB isn't very large, and the times for inserts that you are seeing is not normal.