Radomyselskiy, Mikhail (IT) wrote:
We need an engine that runs completely in
memory without disk use and that doesn't have to be thread-safe
Mikhail,
You should be able to use an SQLite memory database. Use the sqlite
command shell by starting sqlite3 without a database filename argument,
or use the sqlite3_open API function with a file name of ":memory:".
This will give you an in memory database that operates the same as a
file database except it doesn't do file I/O and, because access is
restricted to a single process, doesn't need to do locking. It can
however use a lot of RAM, and it isn't saved when you quit.
HTH
Dennis Cote
