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:


"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.








Reply via email to