Thanks guys for the responses. My program only needs the database as long as the process still exists so I don't need to copy it on a database file.
The memory resident option ":memory:" is perfect. Thanks again. Mihai Limbasan wrote: > > Ribeiro, Glauber wrote: >> 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? >> > Oh, of course, I misunderstood the original question. My apologies. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Memory-Resident-Database-tp19830584p19855290.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
