Quote:
Originally Posted by ETInteractive.com
# Stored Procedures
# Triggers
# Views
|
I would just be happy if they would stop using seperate "SELECT COUNT(*)" queries to calculate the total navigation pages and instead just use "SELECT FOUND_ROWS()" which is far faster and far less resource intensive.
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#id3078928
__________________
X-Cart Pro 4.5.5 Platinum
X-Payments 1.0.6
PHP 5.3.14
MySQL 5.1.68
Apache 2.2.23
|