Hi If you have available memory you can create a ramdisk and mount it as a standard filesystem, then put your database there.
This is quite trivial, if you have /dev/shm you can use tempfs. aka: #mkdir /mnt/ramdisk #mount -t tempfs -o size=8G /dev/shm /mnt/ramdisk Creates a 8Gig ramdisk. The kernel usually gives you 50% of your memory available to /dev/shm, you can make your ramdisk as large as you want, but avail swapping at all costs. -- MortenB --- jack wu <[EMAIL PROTECTED]> wrote: > > in the documentation: "Appropriate Uses For SQLite" > it > says: > > "it is often easier and quicker to load the data > into > an in-memory SQLite database and use queries with > joins and ORDER BY clauses to extract the data in > the > form and order needed rather than to try to code the > same operations manually" > > i am wondering if there are more > information/documentations on how to do that? > > i am writing an application where i need to define > couple of huge hash tables. i load the data from > disk, > populate the hash tables and use the tables during > execution. can i replace the hash tables using > SQLite? > i am new to SQLite, so any information is helpful. > > jack. > > > > >
