Benjamin,
This works well on Linux using file system /dev/shm. This should be
installed as default and works indistinguishably from normal file
system. SQLite writes about 200 times faster than normal file system.
Remember that like all ram disks, this is wiped without warning on
shut-down. So consider it only for duplicate data. I also find having
an 'rc' script to re-create tables on startup is a great help.
David Pitcher wrote:
Salut Benjamin,
Simplest way to make that happen is to use a ram disk, google for
'RamDisk' and the platform you are using. Then you can use the existing
sqlite binary/library but all I/O occurs in memory.
When you want to persist, you just copy it to a hard disk...
D.
