Mysql/php database performance question

From: 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

« previous php.general (#131091) next »