Performance for how many columns to update?
| From: | Leif K-Brooks | Date: | Sun, 10 Nov 2002 17:04:57 +0000 |
| Subject: | Performance for how many columns to update? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23185@lists.php.net to get a copy of this message | ||
I'm wondering how significant the performance differences between:
mysql_query("update table set col1='val1' where whatever='whatever'");
and
mysql_query("update table set col1='val1',col2='val2',col3='val3'... where whatever='whatever'");
--
The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it
will be prosecuted to the full extent of the law.