I'm using MS Access 2007 for insert and read data in my application but it's really slow.
I've got a long running application and if I run it from the memory it takes about 5 minutes, with MS Access 2007 it takes about 13 minutes!
I'm looking for a faster yet portable database option, I'm using .NET . I'm not looking for advanced relational database stuff, as soon as it works like a decent database, it's enough for me.
EDIT :
I'm mostly doing concurrent inserts from multiple threads.
RESULTS
I've tried SQL Server Compact Edition 3.5 SP1 and it's almost same with running from memory so %400 times faster than access + instead of a 72MB of dependency I've got 1.5MB dependency which is great.
P.S. Database is normalised, clean, compacted and I'm using stored_procedures and native client. So I've tried so many things to make it faster already.
SQLite
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With