Re: [GENERAL] Primary Key Performance with INTEGER vs. VARCHAR

2007-07-24 Thread Merlin Moncure
On 7/21/07, Siah <[EMAIL PROTECTED]> wrote: Hi, Designing my application, I was wondering if having my primary keys (to be indexed) with VARCHAR brings performance down significantly? My own test didn't show much difference. Thinking about it though, I'd guess Integer Indexing should be much qui

Re: [GENERAL] Primary Key Performance with INTEGER vs. VARCHAR

2007-07-24 Thread Jim Nasby
On Jul 21, 2007, at 5:49 AM, Siah wrote: Designing my application, I was wondering if having my primary keys (to be indexed) with VARCHAR brings performance down significantly? My own test didn't show much difference. Thinking about it though, I'd guess Integer Indexing should be much quicker and