You must be able to work remotely with teamviewer or anydesk.
You must have experience with Hikashop to complete this task
You must know how to use Joomla Debugger
You must be able to do work right now
DO NOT BID IF YOU CAN ANSWER YES TO ALL ABOVE
Remove joins that are not needed to display search/filter results
All data and columns needed are in 1 table but hikashop joins product table to categories table
We need to remove joins to categories table to increase 5-6 slow queries
When tested query with only products , results are returned in .09 sec
When tested with join to categories queries take up to 8 sec times 5
I want all unescessary joins and queries removed
If you show good progress i will continue to give you more work and tasks
that are similar to improve performance and function of site.
There is no cpanel so dont ask.
There is no ftp so dont ask
Again this is to be completed directly on server in notepad
Dont waste my time and i will leave good feedback