slow prestashop 400.000 products on siteground cloud server


I have a client with a huge catalog on prestashop

([url removed, login to view] upgraded to with some issues).

The shop runs some slow query, especially in category class.

They takes some times more than 150sec. They seems to be due to the random module in homepage (which I removed now), but the situation is not so improved.

The main goal would be to achieve at maximum 2 sec of pageloading time,

I don't know if the solution is improving prestashop and server settings (actually a managed cloud on siteground, 2 cores 6 GB RAM and 40 GB SSD) or moving to a faster not managed server (for example OVH 32 GB ram 8 core and 300GB SSD).

In second case I need someone who set the apache server from scratch, install everything a normal web developer needs and help me settings prestashop to fly.

ps. Main cache settings are set based on lot of tutorials and suggestions, tried lot of combinations but still too slow

thank you for your time guys!

Compétences : Apache, Linux, MySQL, Prestashop

en voir plus : web developer tutorials, web developer prestashop, web developer homepage, web based tutorials, random tutorials, query tutorials, developer tutorials, cloud server, set cloud server mosso, list products prestashop, create products prestashop csv, upload products prestashop, auto update products prestashop, related products prestashop, update products prestashop, import products prestashop, mosso cloud server

Concernant l'employeur :
( 0 commentaires ) venezia, Italy

Nº du projet : #8470859

12 freelance font une offre moyenne de £176 pour ce travail


Hello ! I must say that 400k is quite a large amount of items to list, and prestashop is not actually the best on the market when it comes to speed. I would like to know more about the server config, have you carrie Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(116 Commentaires)

Hello. I am ready to take a look at the site and provide a possible best solution. Have a lot of experience in both Prestashop and performance optimization projects. Thanks. Eugene

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(98 Commentaires)

Hi, I'm a experienced System and Network administrator with more than 10 years of experience with Debian, Slackware, FreeBSD, OpenBSD, Solaris and others Linux and Unix flavors. Now I'm a System Administrator for the Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(24 Commentaires)

Hello, my name is Nikos and I'm working on the Linux server administration field for the past 5 years. Over these years I was responsible for two web hosting companies, managing at full their servers and providing cust Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(59 Commentaires)

Hello, I can analyse and optimize the server to get the best performance possible out of the server's hardware I have done a lot of similar projects on the past you can see reviews on my profile. here is a lit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(33 Commentaires)

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(17 Commentaires)

Hello. I can help you! I'm not very good familiar with prestashop but I'm good investigator (look at my reviews :) And I'm 10+ years experience of system administration, and php dveloper in the past and network engen Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(9 Commentaires)

Dear employer, I am system administrator with 4+ years experience. I am familiar with high traffic application and big data I will fix your problem and write document for that :)

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(14 Commentaires)

Nie złożono jeszcze oferty.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(19 Commentaires)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(5 Commentaires)

Hello there, From my experience the ideal setup is as follows. A VPS machine just for mysql. You need CPU like 4-6 cores on let's say 4-8 GB RAM. Another VPS machine for apache (we can use haproxy in front of a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(2 Commentaires)

Price for case study, bottleneck search, and solution suggestion. Implementation will depend on solution chosen.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)

2 second is fast for prestashop solution. I developed presta solution for speed and latency.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)