Naming the database ':memory:' (without the quotes) will not create a
file but place the database in memory.
Needless to say - it will not remember tables created their after
disconnection, and will use RAM up :-)
Eddy
jack wu wrote:
in the documentation: "Appropriate Uses For SQLite" it
says:
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
i am thinking of real time analysis of web logs. so it
could be huge if i save all the logs. of course
size/system/cpu could be different depending on the
web site this application runs on.
--- Roger Binns <[EMAIL PROTECTED]> wrote:
> > i am writing an application where i need to define
> >
i am writing an application where i need to define
couple of huge hash tables.
What is your idea of huge and what operating system/CPU are
you running on?
Roger
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
5 matches
Mail list logo