Mysql/php database performance question
| From: | Simon Dedeyne | Date: | Fri, 10 Jan 2003 11:54:15 +0000 |
| Subject: | Mysql/php database performance question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131091@lists.php.net to get a copy of this message | ||
Hi,
I got a question about using Mysql databases.
I load textdata in VARCHAR colums up to size 50. I have about 5 of those
columns.
The last columns often contain empty cells. (data are wordmeanings, many
words have only a 1 or 2meanings)
What would be faster/better:
- putting everything in a big varchar column (size 5x50) and PHP parsing
them by comma after
fetching
or
- keeping those 5 columns with a lot of empty cells in the last columns?
Thanks,
Simon