RE: [PHP] Mysql/php database performance question
| From: | Matt Schroebel | Date: | Fri, 10 Jan 2003 14:52:53 +0000 |
| Subject: | RE: [PHP] Mysql/php database performance question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-131114@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Simon Dedeyne [mailto:Simon.Dedeyne@psy.kuleuven.ac.be]
> Sent: Friday, January 10, 2003 9:03 AM
> To: php-general@lists.php.net
> 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.