Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Something faster than MS Access 2007, Fast Portable Database Recommendations?

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.

like image 328
dr. evil Avatar asked Dec 06 '22 06:12

dr. evil


1 Answers

SQLite

like image 196
Romain Verdier Avatar answered Jan 06 '23 02:01

Romain Verdier