Fermé

slow prestashop 400.000 products on siteground cloud server

Hi,

I have a client with a huge catalog on prestashop

([url removed, login to view] upgraded to 1.6.1.1 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

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 ont fait une offre moyenne de 176 £ pour ce travail

drailean

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

244 £ GBP en 7 jours
(116 Commentaires)
6.1
webxtor

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

144 £ GBP en 3 jours
(98 Commentaires)
5.6
rmmarconi

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

150 £ GBP en 5 jours
(24 Commentaires)
5.7
nikosku

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

125 £ GBP en 1 jour
(59 Commentaires)
5.2
slimhack

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

177 £ GBP en 2 jours
(33 Commentaires)
5.0
VnBestSolutions

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

247 £ GBP en 3 jours
(17 Commentaires)
4.5
YuriGoncharov

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

100 £ GBP en 2 jours
(9 Commentaires)
4.0
ngoaipho

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 :)

150 £ GBP en 2 jours
(14 Commentaires)
3.7
nSolutionsPL

Nie złożono jeszcze oferty.

150 £ GBP en 3 jours
(19 Commentaires)
3.8
jgamio

A proposal has not yet been provided

222 £ GBP en 15 jours
(5 Commentaires)
2.8
bms8197

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

138 £ GBP en 3 jours
(2 Commentaires)
1.3
Menren

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

167 £ GBP en 3 jours
(0 Commentaires)
0.0
SeoWisePro

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

250 £ GBP en 5 jours
(0 Commentaires)
0.0