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
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
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
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
: [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
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
?
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
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
[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
] [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
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
11 matches
Mail list logo