You probably want to open your in-file database, open the :memory: database, and copy all the data from the file to memory, do your manipulations in memory, then copy back to file when you're done.
http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase has a simple TCL program to copy a database, which you could adapt to C# If this database is read-only, maybe pragma journal_mode = off would get you enough performance? -----Original Message----- From: Mihai Limbasan [mailto:[EMAIL PROTECTED] Sent: Monday, October 06, 2008 1:10 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Memory Resident Database marcglennjamon wrote: > Hello guys, > > Is there an option in SQLite to make the database file reside in the > memory during sql transactions for faster access? > I am using the C# language under Mono. > > Thanks in advance, > Marc Glenn > Yes - use ":memory:" (without the double quotes) as the database name when opening it. Be aware, though, that all tables and their contents will disappear once you close the database connection. HTH, Mihai Limbasan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
