Re: [sqlite] Char versus Float versus Int as primary key

2006-03-10 Thread Dennis Cote
cstrader wrote: I'm looking to enhance query speed. Does it matter what variable type I use as the primary key? I'm thinking numbers might be faster than strings, but I'm not sure. Thanks! Integer primary keys will be the fastest since SQLite optimizes this case by not creating a

Re: [sqlite] Char versus Float versus Int as primary key

2006-03-10 Thread Jay Sprenkle
> > Jay... I could do that and maybe will. But does anyone know whether it > SHOULD matter? Or are you saying that there are no general principles in > this regard? I would think the difference would be pretty minimal but I don't know for sure. It would seem to be quicker to test than

[sqlite] Char versus Float versus Int as primary key

2006-03-10 Thread cstrader
Jay... I could do that and maybe will. But does anyone know whether it SHOULD matter? Or are you saying that there are no general principles in this regard? Thanks..

Re: [sqlite] Char versus Float versus Int as primary key

2006-03-10 Thread Jay Sprenkle
On 3/10/06, cstrader <[EMAIL PROTECTED]> wrote: > I'm looking to enhance query speed. Does it matter what variable type I use > as the primary key? I'm thinking numbers might be faster than strings, but > I'm not sure. > > Thanks! > > Try it and see :)

[sqlite] Char versus Float versus Int as primary key

2006-03-10 Thread cstrader
I'm looking to enhance query speed. Does it matter what variable type I use as the primary key? I'm thinking numbers might be faster than strings, but I'm not sure. Thanks!