Speed Hit with MySQL TEXT fields?
| From: | phobo | Date: | Thu, 01 Feb 2001 05:21:10 +0000 |
| Subject: | Speed Hit with MySQL TEXT fields? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6304@lists.php.net to get a copy of this message | ||
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