massive MySQL tables
| From: | Justin French | Date: | Mon, 08 Oct 2001 22:22:32 +0000 |
| Subject: | massive MySQL tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-70396@lists.php.net to get a copy of this message | ||
Hi all,
Sorry for being slightly OT, but I'm working on a site with a large
application form (84 fields) which people have to fill in. The form is
rendering in the browser pretty quick (my first worry), but now I'm
concerned that 85+ data fields in MySQL might create performance
problems on the server.
Is this likely?
Most fields are "medium text" or "varchar", and will not need to be
searched at all, so i'll prolly just index the two or three important
ones, and leave it at that.
If there is likley to be a performance hit, what other options will I have?
Justin French