Re: [sqlite] a string indexing experiment

Arun Bhalla <[EMAIL PROTECTED]> wrote: > Hi, > > I performed a quick benchmark of three different string indexing schemes > for SQLite3. > > * Scheme 0 = indexing on the string field > * Scheme 1 = indexing on the MD5 sum (as text in hexadecimal > representation) of the string > * Scheme

Re: [sqlite] a string indexing experiment

I forgot to mention -- I was using SQLite 3.3.4. Arun Bhalla wrote: Hi, I performed a quick benchmark of three different string indexing schemes for SQLite3. * Scheme 0 = indexing on the string field * Scheme 1 = indexing on the MD5 sum (as text in hexadecimal representation) of the

[sqlite] a string indexing experiment

Hi, I performed a quick benchmark of three different string indexing schemes for SQLite3. * Scheme 0 = indexing on the string field * Scheme 1 = indexing on the MD5 sum (as text in hexadecimal representation) of the string * Scheme 2 = indexing on the high 64 bits of the MD5 sum (as int)