We have a eCommerce portal running in OpenCart, we are looking for a OpenCart expert developer who can check the search functionality issue and resolve it. Search is taking very long time to get result and many times it is also showing time out error. If someone resolve this issue than we can also work on some more issues as well we are facing on the portal.
Note- We have approx 25L of items in our product table now, this also may be the reason that search is taking time because name column is not indexed. But when we are running same searched query in SQL than it is taking 3-4 sec to get the results.
I am willing to pay higher rates for the most experienced freelancers