Urgent: Need a Webmaster to optimize my Prestashop Slow SQL queries and website performance - repost 2

Hello experts,

My website is running Prestashop and It's shared on a powerful VPS

But lately it's suffering from slow performance and potentially 503 errors.

My hosting company reported a number of SQL queries which need to be well optimized to resolve the slow queries issue.

I need an SQL expert who can optimize these SQL Queries to a faster one, and also he should be an expert in Web hosting master to be able to study my current website performance and help to optimize its speed and performance.

Please I need a guarantee from your side that the latency and slow performance will be resolved.

Here is the log for the slow queries that are causing the latency

[url removed, login to view]

definitively it's not required to optimize all, but if we found the root cause, this log will be minimal.

I need this task to be performed ASAP, the most experienced and lowest bid will be selected.


Skills: MySQL, PHP, Prestashop, Software Architecture, Web Hosting

See more: prestashop log slow queries, webmaster expert, i need a php expert's help, urgent need php, sql queries, slow speed, prestashop performance, optimize sql queries, sql optimize, optimize website speed, running faster, expert vps, slow queries, optimize vps prestashop, vps expert, prestashop slow vps, need help vps, optimize sql prestashop, php sql txt, vps prestashop, optimize web, vps asap, need website asap repost, web hosting expert required, performance optimize

About the Employer:
( 17 reviews ) Abu Dhabi, United Arab Emirates

Project ID: #4621369

6 freelancers are bidding on average $127 for this job


Optimization expert.

$189 USD in 2 days
(176 Reviews)

I can see two distinct queries that appear to be slow. Please see my recommendations in PM.

$157 USD in 3 days
(38 Reviews)

plz check PMB.

$105 USD in 3 days
(60 Reviews)

Hi, we are a team of programmers and designers with expertise and experience in PHP, Mysql, jQuery and Ajax. We have coded and designed websites for various types of businesses very successfully. We have developed many More

$93 USD in 3 days
(48 Reviews)

Please read PMS for more detail..many thanks..

$144 USD in 3 days
(15 Reviews)

Hello, I can help.

$138 USD in 3 days
(5 Reviews)

I just went through the text file containing queries. I have observed that all the queries contain Sub Queries and there are a lot of nested IN statements. This would eventually affect the performance as your database More

$100 USD in 3 days
(13 Reviews)

i'm 14+ years experienced with Prestashop integration knowledge, ready to start

$115 USD in 5 days
(9 Reviews)