Currently I'm thinking about replacing the usage of Microsoft Jet MDB databases on a single-user .NET C# Windows Forms application by a SQlite database.
My goal is to lower installation requirements like the Jet drivers and some nasty errors when the Jet installation got corrupted (we have customers every now and then reporting those errors).
My question regarding performance is:
Are there any performance benchmarks out there comparing MDB and SQLite on a rather small sets of data?
Or are there any developers who already did this step and can tell some stories from their own experiences?
(I am googling for hours now without success)
Update
Although the database does not contain that many records and tables, I think performance is still an issue, since the data is being accessed quite often.
The application is a so called "Desktop CMS system" that renders HTML pages; during the rendering, quite a lot of data is being accessed and lots of SQL queries are being executed.
Update 2
Just found this documentation which indicates some speed comparisons, unfortunately not with MDB, as far as I can see.
Update 3
As of request, some figures:
- approx. 30 tables in the database.
- Most tables with way below 100 records.
- approx. 5 tables with usually a few 100 up to a few thousand records.
- A large MDB file would be around 60 MB.
Update 4
Just to rephrase: I am not having any performance issues with the current MDB implementation. I am asking this question to get a feeling whether the performance would be equal (or better) when using SQLite instead of MDB.