Re: [sqlite] Memory Resident Database

2010-10-25 Thread durgadevi
Hai, I am using SQLite with c.To increase the performance I am using inmemory Database. How Can I view the contents stored in the inmemory database? Please help me. Regards, B.Durgadevi marcglennjamon wrote: > > Hello guys, > > Is there an option in SQLite to make the database file resid

Re: [sqlite] Memory Resident Database

2008-10-07 Thread marcglennjamon
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 y

Re: [sqlite] Memory Resident Database

2008-10-06 Thread Mihai Limbasan
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 pro

Re: [sqlite] Memory Resident Database

2008-10-06 Thread Ribeiro, Glauber
t: 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, &

Re: [sqlite] Memory Resident Database

2008-10-05 Thread Mihai Limbasan
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 da

[sqlite] Memory Resident Database

2008-10-05 Thread marcglennjamon
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 -- View this message in context: http://www.nabble.com/Memory-Resident-Database-tp1