Hi,
has anybody tried this module on a shop with more that 1500 products in database. (Plus x-sell, specials, featured).
It takes approx 4 minutes to open product info page.
I noticed that the query ($btpq) generated by buy_two_module.php takes too long to select a random product.
Any suggestion will be appreciated
The query is here:
select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price, p.manufacturers_id from products p left join specials s on p.products_id = s.products_id , products_attributes pa where p.products_id != pa.products_id and p.products_status = '1' and p.products_id!='1474' and p.products_tax_class_id='0' order by rand(23469) DESC limit 1