RE: [sqlite] How to store 128 bit values

2007-07-11 Thread RB Smissaert
- 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

Re: [sqlite] How to store 128 bit values

2007-07-11 Thread drh
"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

RE: [sqlite] How to store 128 bit values

2007-07-11 Thread RB Smissaert
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

Re: [sqlite] How to store 128 bit values

2007-07-11 Thread drh
"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

Re: [sqlite] How to store 128 bit values

2007-07-11 Thread Scott Hess
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

Re: [sqlite] How to store 128 bit values

2007-07-11 Thread Andrew Finkenstadt
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

[sqlite] How to store 128 bit values

2007-07-11 Thread Steve Krulewitz
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