Re: Speed (char or integer)

2001-08-07 Thread ryc
A numeric value will be faster in most cases. The reason being that a comparison between two numbers at most takes 1 comparison... but a comparison for a char at most takes n comparisons (n being the length of the field/string). In addition a numeric value would take less space... all around its a

RE: Speed (char or integer)

2001-08-07 Thread Carsten H. Pedersen
> I have a table with (char)Username attribute which is the primary > key of the table and also acts as a foreign key in many other tables. > > My question is if the queries would be faster if i used a numeric > value for the primary key? Integers would be faster, but the question is really