Try to see the reply, at
http://www.mail-archive.com/sqlite-users@sqlite.org/msg19255.html
...
Chetana
- Original Message
From: Dave Gierok <[EMAIL PROTECTED]>
To: "sqlite-users@sqlite.org"
Sent: Monday, November 6, 2006 10:10:39 PM
Subject: RE: [sqlite] Sqlite DB
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"
Sent: Monday, November 6, 2006 10:10:39 PM
Subject: RE: [sqlite] Sqlite DB
: 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?
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 you'
: [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 t
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
ill cached?
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:
>
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 creating
[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 row
PROTECTED] [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 th
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 of
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 of 92KB instead of what I'd expect
to be around 40
12 matches
Mail list logo
