Need A MySQL and PHP Expert with skill of Opencart
$50-200 USD
Cancelled
Posted over 9 years ago
$50-200 USD
Paid on delivery
We are looking for a mysql and php expert, who can improve the loading speed of an opencart site. Currently, we have slow loading speed.
We are running opencart-1.5.6.1 and Waabay multivendor dropshipper vqmod. We have had quite a few customizations already done, one of which is the geolocation-based search function.
To find all vendors and their products, our database has to do a lot of work. For each listing in the database, we need to calculate the distance within 15 mile radius. This calculation and sort is just very slow. So we would need someone who has profound skill of MySQL, PHP and Opencart and can create spatial indexes to precalculate the distance points in MyISAM table.
The result shall be below 2s for server response for location-based queries with sub-categories and products without a plugin. Anything above that loading speed is unacceptable.
We only consider developers with experience in developing similar projects. We need someone who is an expert in mysql & php and knows opencart extremely well work on this task.