The original post states:
Quote:
|
The key to this code speed increase is the usage of COUNT(*) instead of COUNT($sql_tbl[products].productid).
|
If you look at your original code, you see that the function is:
Code:
return func_query_first_cell("SELECT COUNT(*) FROM $sql_tbl[products] WHERE forsale!='N'");
therefore this modification is not for you. You do not need it.
COUNT(*) is already written into that function in your version of X-Cart.