I may fine the reason that I didn't put brand id for all the import products and that makes It takes much longer time to load those products.
And when I use the back end interface to add the brand, the loading speed came back.
Since there are about 1200 import products, instead of change the brand one by one, I use the following SQL command to update it.
UPDATE igc8d_hikashop_product SET product_manufacturer_id = 91 where product_manufacturer_id=0
After that, I checked it from back end and all looked fine. But in the front end, the loading speed is still low. So I choose one product, change the brand manually, the loading become normal. Could you show me how to massively change all those products?
==================================
here are two products, one by update sql, one by manual
update SQL(Slow)
www.livetv.com.tw/index.php/template-hik...BC%E7%9C%BC%E7%BD%A9
manual(fast)
www.livetv.com.tw/index.php/template-hik...BA%E6%B0%A3%E7%B5%84
Thanks
Best regards