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

Question

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.*

Answer 1

SQLite

Answer 2

SQL Server Express 2008. It's free, and it's SQL Server.

Answer 3

Microsoft SQL server worked for my applications, although I would rather use MySQL. I am sure MSSQL has great integration into .NET, though, so it is probably fastest.

Answer 4

From the sqlite wiki:

SQLite is the speed demon of choice for systems that don't make heavy use of concurrent connections and complicated database features. If you need a lot of concurrent connections, SQLite probably isn't the best choice. But if you need a lot of speed and a simple setup for a single connection, SQLite is the best thing I've seen.

http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations

You might also want to take a look at mysql, pgsql or mssql (CE or Express (Both Free)), depending on your needs.

---

Edit: Based on your comments, you will probably need something that runs on a server like mysql, pgsql or mssql (express)

---

Edit2: If you are mostly doing inserts, make sure you don't have unused indexes in your table, since indexes can make insert/updates a bit slower.

Answer 5

Honestly, I don't think you're going to get much faster results. Your program is probably I/O bound, which means that the speed of the disk is slowing you down.

You can try SQL Compact Edition (CE), but I suspect you will see as slow or slower results from any other tool.

Answer 6

You can also use Firebird : www.firebirdsql.org

It's free and very easy to use. There is some good .net drivers.

If you sell your application : MySQL is not free.