Missing index for product alias

  • Posts: 24
  • Thank you received: 1
2 hours 43 minutes ago #369857

-- HikaShop version -- : 6.1.1
-- Joomla version -- : 5.4.1
-- PHP version -- : 8.3

Assuming that routing queries DB for product alias on each product page load, the query during routing doesn't use index:

SELECT product_id
FROM jos_hikashop_product
WHERE product_alias = 'iphone-17-pro'

It's important to add index for product_alias column.
Same for category_alias in #__hikashop_category table.

Please Log in or Create an account to join the conversation.

Time to create page: 0.051 seconds
Powered by Kunena Forum