> -----Original Message----- > From: Simon Dedeyne [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 10, 2003 9:03 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] Mysql/php database performance question
> So I think I have to reformulate the question: which is > better 5 varchar columns of size 50 or 1 varchar column of size 250 > (regardless of parsing). You ought to read the mysql manual on that. http://www.mysql.com/doc/en/MyISAM_table_formats.html Where's the pain? The trade off between char and varchar is speed vs table size. Are just trying to be as fast as possible? If the db is small, I wouldn't worry about it and do what ever way you want (i.e. what's a microsecond or two?) You could try both ways and profile it several thousand times to see if it really matters. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
