Thanks guys. One more question: When is the memory of the in-memory database released? Is it when the close() function is called?
Are there any other memory clean-up which needs to be done? Rajan >-----Original Message----- >From: Igor Tandetnik [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 20, 2005 3:22 PM >To: SQLite >Subject: [sqlite] Re: Re: in memory SQLite in C/C++ > >Rajan, Vivek K wrote: >> One question: So at any given point in time, one can only have _ONE_ >> SQLite database in-memory? > >If I understand it correctly, every sqlite3_open(":memory:") call >creates a separate, independent in-memory database. So you can have many >such databases open at the same time, but you can't have two handles >open on the same in-memory database (the way you can on a file). > >Igor Tandetnik
