Re: [sqlite] Sqlite DB file sizes

2006-11-06 Thread chetana bhargav
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 f

Re: [sqlite] Sqlite DB file sizes

2006-11-06 Thread chetana bhargav
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 f

RE: [sqlite] Sqlite DB file sizes

2006-11-06 Thread Dave Gierok
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

Re: [sqlite] Sqlite DB file sizes

2006-11-02 Thread drh
Dave Gierok <[EMAIL PROTECTED]> wrote: > 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? Could you poin= > t me in the right direction? We are in a real shortage for RAM in our game= > .. The routines

RE: [sqlite] Sqlite DB file sizes

2006-11-02 Thread Dave Gierok
: [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 wa

Re: [sqlite] Sqlite DB file sizes

2006-11-01 Thread drh
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

RE: [sqlite] Sqlite DB file sizes

2006-11-01 Thread Dave Gierok
? Thanks, Dave Gierok -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 4:27 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite DB file sizes Dennis Cote <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > Dave

Re: [sqlite] Sqlite DB file sizes

2006-11-01 Thread drh
Dennis Cote <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > Dave Gierok <[EMAIL PROTECTED]> wrote: > > > >> It looks like the size of a Sqlite DB ends up being much larger > >> (more than 2x) than size that I calculate for its data set. > >> > >> A simple test shows that when

Re: [sqlite] Sqlite DB file sizes

2006-11-01 Thread Dennis Cote
[EMAIL PROTECTED] wrote: Dave Gierok <[EMAIL PROTECTED]> wrote: It looks like the size of a Sqlite DB ends up being much larger (more than 2x) than size that I calculate for its data set. A simple test shows that when creating one table with one integer column and filling it with 1

RE: [sqlite] Sqlite DB file sizes

2006-11-01 Thread Dave Gierok
] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 11:38 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite DB file sizes Dave Gierok <[EMAIL PROTECTED]> wrote: > It looks like the size of a Sqlite DB ends up being much larger > (more than 2x) than size that I calcu

Re: [sqlite] Sqlite DB file sizes

2006-11-01 Thread drh
Dave Gierok <[EMAIL PROTECTED]> wrote: > It looks like the size of a Sqlite DB ends up being much larger > (more than 2x) than size that I calculate for its data set. > > A simple test shows that when creating one table with one integer > column and filling it with 1 rows, I get a DB size