Hi,
I have recently converted a "problem application" from MS-Access to SQLite
in Visual Basic but the performance is really worse then with Access. I have not
changed much in the application code except for a few things that should be in
favour
to sqlite, like implementing a second "in memory" database for temporary data
and disc
based write-to db.
Has anyone tested and concluded that sqlite is faster for small databases (<5000
records)
so I don't sit here in vain, trying to optimize for something that just can't be
done?
Inserts are done in a transaction (extremely good prestanda here),
selects are indexed (could this be a problem in a table with 2-3 000 records?) by
adding too much overhead compared to a non-indexed, sequential, search?
regards /Jonas
