-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 11 July 2007 20:17
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to store 128 bit values
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> > Looking up a record by INTEGER PRIMARY KEY is always twice as
> > fast
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> > Looking up a record by INTEGER PRIMARY KEY is always twice as
> > fast as looking up the same record by any other key
>
> Didn't realize that, but I have a question in connection with this.
> It seems if you do inserts on a table it is faster if you ha
L PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 11 July 2007 19:33
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to store 128 bit values
"Steve Krulewitz" <[EMAIL PROTECTED]> wrote:
> Hey all --
>
> In the application I am working on (Songbird), we have a simple
"Steve Krulewitz" <[EMAIL PROTECTED]> wrote:
> Hey all --
>
> In the application I am working on (Songbird), we have a simple two
> table schema representing the tracks in your music collection and the
> properties on those tracks. The keys used are all UUIDs (128 bit
> number) which we are curre
On 7/11/07, Steve Krulewitz <[EMAIL PROTECTED]> wrote:
In the application I am working on (Songbird), we have a simple two
table schema representing the tracks in your music collection and the
properties on those tracks. The keys used are all UUIDs (128 bit
number) which we are currently storing
On 7/11/07, Steve Krulewitz <[EMAIL PROTECTED]> wrote:
I was wondering if there is much to be gained by storing these 128 bit
values in binary rather than as strings. We estimate roughly 20
properties per track, so in a moderate sized database you'd have 10k
rows in the tracks table and 200k ro
Hey all --
In the application I am working on (Songbird), we have a simple two
table schema representing the tracks in your music collection and the
properties on those tracks. The keys used are all UUIDs (128 bit
number) which we are currently storing in hex string form in a text
column, so the
7 matches
Mail list logo