datatypes and speed

[Anon]

Hi,

I'm trying to decide between the (var)char and int datatypes for a primary key column. I'll be referencing this column often for table joins and such. I've heard that MySQL can reference integers faster than strings, however I'm still leaning towards using the char datatype because it will allow me to eliminate the need for a few table joins later on.

Is there a compelling reason why I should use an int datatype for the primary key instead?

Thanks,

setic

[[deleted]]

"Is there a compelling reason why I should use an int datatype for the primary key instead?"

The fact that auto_increment only works on integers should be more than enough.

A note: the primary key is a means of indentifying data internalling inside the database. Hence, strings are completely useless there.

Use integers, you'll love yourself later.