Re: [sqlite] Working with database entirely from memory

n't do any improvement? Yaniv Pe'er Programmer, Artist, Game Developer [[ http://www.GroteskAndMonstrous.com ]] -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, July 07, 2006 2:58 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Working with database entirely f

RE: [sqlite] Working with database entirely from memory

sqlite.org Subject: Re: [sqlite] Working with database entirely from memory Open it to :memory. You won't find much improvement, if any. Yaniv Pe'er wrote: > Hi all, > > I wish to load my entire database to the program memory and work with it > through there without having to use the h

Re: [sqlite] Working with database entirely from memory

My reason is mostly to increase performance since this is a relatively small database and will be accessed constantly. Its size is also not likely to increase much. You don't define what "small" is. You should first make sure you even have a problem. SQLite does in memory buffering anyway

Re: [sqlite] Working with database entirely from memory

Open it to :memory. You won't find much improvement, if any. Yaniv Pe'er wrote: Hi all, I wish to load my entire database to the program memory and work with it through there without having to use the hard drive at all (Well, besides the initial loading). My reason is mostly to increase

[sqlite] Working with database entirely from memory

Hi all, I wish to load my entire database to the program memory and work with it through there without having to use the hard drive at all (Well, besides the initial loading). My reason is mostly to increase performance since this is a relatively small database and will be accessed constantly.