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:
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?
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
