In a database with no more than 100 rows, is it better to have several (a
dozen or so) large column sizes (200-300 bytes), or to have TEXT fields; as
many of the columns can be from null to full-use ... I'm not worried about
diskimprint; only speed ... All look-ups are done on the primarykey, which
is indexed, so a fixed size will make lookup almost instant, whereas dynamic
sized records will slow this down ... is this slow down considerable (MySQL,
PHP, Apache / Redhat server) ??

Is there a disussuion of this somewhere?

Siggy


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to