Re: Mysql/php database performance question
| From: | Brent Baisley | Date: | Fri, 10 Jan 2003 20:17:23 +0000 |
| Subject: | Re: Mysql/php database performance question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-131179@lists.php.net to get a copy of this message | ||
I'm coming in a little late on this thread, but I would suggest structuring you data differently.
I would have two tables: words and meanings. Then you won't have any null fields and you won't limit yourself to just 5 definitions. It will also be a heck of a lot easier to setup a full text index on the "meaning" since you only need to index one field instead of 5.
On Friday, January 10, 2003, at 10:49 AM, Maxim Maletsky wrote:
Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577What 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? --