Hi David
We have a very large DB with over 3million products and growing, and it seems we have come to the limit as our server keeps crashing, tried everything even moving servers which has stopped the crashing but with the downside of it being slower.
We have rewritten the string so that all products are on top level ie domain.com/product- rather than domain.com/product/. We now have good uptake on these links and don't want to lose them, but we have to do something and the obvious decision is to split the database down into sections such as domain.com/clothing/products-, however we would like to keep the original links.
The question is
Could the links within the new sections for the products be rewritten to the original links so the link to domain.com/clothing/product-item.html would be domain.com/product-item.html.
I hope this makes sense, any advise would be appreciated.
Brent
Hello Brent,
I think it would have to be done by trial-and-error; but if performance in your cut-down categorised installations is fine that's probably an acceptable trade-off.
With a Price Tapestry installation in the top-level folder as well as your individual /category/ installations differentiated by $config_databaseTablePrefix you could use something like this at the top of products.php - look for the following code at line 14:
$numRows = database_querySelect($sql,$rows);...and REPLACE with:
$databaseTablePrefix = array("pt1_","pt2_","pt3_");foreach($databaseTablePrefix as $config_databaseTablePrefix)
{
if ($numRows = database_querySelect($sql,$rows)) break;
}
...where pt1_, pt2_ etc. are the different database table prefix values of each installation...
Hope this helps!
Cheers,
David.
--
PriceTapestry.com