Re: [sqlite] Loading a table into memory

2006-11-07 Thread Jay Sprenkle
On 11/7/06, chetana bhargav <[EMAIL PROTECTED]> wrote: I am trying for loading only that table one into memory. Beacuse in my DB I have two or more three table which are quite large and I don't want to waste memory. Is it possible that way. I believe you can attach the database ":memory:"

Re: [sqlite] Loading a table into memory

2006-11-07 Thread chetana bhargav
-users@sqlite.org Sent: Tuesday, November 7, 2006 10:56:07 AM Subject: Re: [sqlite] Loading a table into memory you can use a database named :memory: Is that what you were looking for? On 11/6/06, chetana bhargav <[EMAIL PROTECTED]> wrote: > Hi, > > I have a read only table, whic

Re: [sqlite] Loading a table into memory

2006-11-06 Thread Jay Sprenkle
you can use a database named :memory: Is that what you were looking for? On 11/6/06, chetana bhargav <[EMAIL PROTECTED]> wrote: Hi, I have a read only table, which is very small(Bytes of storage consumed. 1024 from the analyzer). I am wondering is there any way to load this

[sqlite] Loading a table into memory

2006-11-06 Thread chetana bhargav
Hi, I have a read only table, which is very small(Bytes of storage consumed. 1024 from the analyzer). I am wondering is there any way to load this table in memory and unload it later. ... Chetana.