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
>
> 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
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..
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 :)
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!
5 matches
Mail list logo