Pls see this message. http://www.mail-archive.com/sqlite-users@sqlite.org/msg19255.html
... Chetana. ----- Original Message ---- From: Dave Gierok <[EMAIL PROTECTED]> To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org> Sent: Monday, November 6, 2006 10:10:39 PM Subject: RE: [sqlite] Sqlite DB file sizes How difficult would it be to change my version of Sqlite such that it uses 32-bit floats instead of doubles for REAL values in :memory: databases (or even all databases)? Could you point me in the right direction? We are in a real shortage for RAM in our game. I appologize if this is the second time this was sent out. It appears as though the last time I sent this it did not make it out -- at least I never received the mail. Thank you very much, Dave Gierok -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 5:12 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite DB file sizes Dave Gierok <[EMAIL PROTECTED]> wrote: > So, how is data represented in a :memory: db? Are :memory: db's different = > in the way they store their data in memory vs. the way a file db stores its= > data to file? Or is it as simple as instead of writing to file, it writes= > to memory? If they are the same, are :memory: db's still cached? > A :memory: db is just the cache with the write-to-disk function disabled. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
