Search takes over 5 minutes

-- url of the page with the problem -- : www.mpxllc.com/estore/inventory
-- HikaShop version -- : 2.2.1
-- Joomla version -- : 2.5

When trying to search products, i.e. 4303, it takes over 5 minutes to show results... is there a better way to get this to run faster, i have over 25000 products, and it is really making me lose my customers because they cannot even find my products using Joomla's search...

Hi,

By adding indexes in the database it is possible to improve performances but in order to know which kind of index you have to create, we have to know more about what fields you making search on.

Regards,

Searching on the Product Name

In addition, when finally getting into the results page, when clicking on the product it takes a long time to load as well. No photo has been added, so i do not know why it is taking this long.

Now all of Hikashop is taking forever to load, even the backend.

Had to re-install Hikashop to finally get it working right....