I want to speedup a simple query like:
select * from tableX where id=<n>
where 'id' is the primary key.
tableX now has variable length records.
Does it help if I make it fixed length (at the cost of space) ?
If, at least theoretically, it does go faster with fixed length
fields can someone explain why ?
Doesn't the indexing take care of finding the desired record
regardless of the length of each record ?
Thanks !
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
