Just wondering if there is any way to speed up the 'backfilling' of reviews, and to a lesser extent, clicks. On my sites with the most reviews, this process is now taking around 6 hours to complete!
The default admin_importReviews() process doesn't involve anything to do with clicks so I'm wondering if that is related to a mod that has been applied as I know you have been using the script for several years and I have helped you with quite a few changes! Just so that I'm up to date, please could you email me a copy of includes/admin.php from this installation, and also create and run the following dbdesc.php script and copy the output into the same email, this will confirm the current products table structure and more importantly what indexes are defined which is an important factor in terms of performance...
Hello Keeop,
The default admin_importReviews() process doesn't involve anything to do with clicks so I'm wondering if that is related to a mod that has been applied as I know you have been using the script for several years and I have helped you with quite a few changes! Just so that I'm up to date, please could you email me a copy of includes/admin.php from this installation, and also create and run the following dbdesc.php script and copy the output into the same email, this will confirm the current products table structure and more importantly what indexes are defined which is an important factor in terms of performance...
<?php
require("includes/common.php");
header("Content-Type: text/plain");
$sql = "DESC `".$config_databaseTablePrefix."products`";
database_querySelect($sql,$result);
print_r($result);
$sql = "SHOW INDEXES FROM `".$config_databaseTablePrefix."products`";
database_querySelect($sql,$result);
print_r($result);
$sql = "SHOW TABLE STATUS";
database_querySelect($sql,$result);
print_r($result);
?>
Thanks!
David.
--
PriceTapestry.com