Contributions
More Optimal Also Purchased Module
This is the continuation of the Contribution : "optimized_also_purchased_module" by Chemo.
What Changed:
1. Removed the count(xx) in the select query because it is not needed by everyone.
2. The while loop calls a function : tep_get_products_name(product_id). This is not an optimal way of accessing a db. I added another join to the original query to get the product_names. That way the loop need not to send another query for each product.
Enjoy at your own risk: *** Backup your work.
 More Optimal Also Purchased Module |
27 Dec 2006 |
This is the continuation of the Contribution : "optimized_also_purchased_module" by Chemo.
What Changed:
1. Removed the count(xx) in the select query because it is not needed by everyone.
2. The while loop calls a function : tep_get_products_name(product_id). This is not an optimal way of accessing a db. I added another join to the original query to get the product_names. That way the loop need not to send another query for each product.
Enjoy at your own risk: *** Backup your work.
Note: Contributions are used at own risk.
