[SOLVED] Very Slow back office load time on certain pages

[Guest]

Some of our customers have hundreds of orders. This is REALLY slowing things down

 

Only on certain pages in the back office for example where we look at customer details or adding an order manually the page can take 45 seconds to load because it is getting hundreds of orders, hundreds of cards, hundreds of messages etc. Takes a long time

 

can any one suggest a way to optimise this?

 

I have done a profile (Attached) but i am hopeless at reading this kind of thing. Can anyway see a bottleneck?

 

I am assuming it is the amount of sql calls that is slowing it down. So is there a way o speeding that up for eample? We have a cloud server with access to WHM. 70 GB disk 3 gb RAM

 

Perhaps allocating more resources to the SQL? If so what is best, ram, cpU etc?

 

Processor Information Total processors: 4 Processor #1 Vendor GenuineIntel Name Intel® Xeon® CPU E5506 @ 2.13GHz Speed 2133.408 MHz Cache 4096 KB Processor #2 Vendor GenuineIntel Name Intel® Xeon® CPU E5506 @ 2.13GHz Speed 2133.408 MHz Cache 4096 KB Processor #3 Vendor GenuineIntel Name Intel® Xeon® CPU E5506 @ 2.13GHz Speed 2133.408 MHz Cache 4096 KB Processor #4 Vendor GenuineIntel Name Intel® Xeon® CPU E5506 @ 2.13GHz Speed 2133.408 MHz Cache 4096 KB

 

Memory Information Memory: 2893760k/3145728k available (5336k kernel code, 388k absent, 251580k reserved, 7016k data, 1288k init)

 

System Information Linux vps.graphskill.co.uk 2.6.32-504.12.2.el6.x86_64 #1 SMP Wed Mar 11 22:03:14 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

 

Physical Disks  

 

Current Memory Usage total used free shared buffers cached
Mem: 2943960 2272968 670992 72 83448 1455880
-/+ buffers/cache: 733640 2210320
Swap: 1048572 316296 732276
Total: 3992532 2589264 1403268

 

Current Disk Usage

Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 69G 53G 13G 81% /
tmpfs 1.5G 0 1.5G 0% /dev/shm
/usr/tmpDSK 2.6G 2.1G 374M 85% /tmp

 

 

Any help / advise would be great

 

Load time.pdf

 

Edited November 15, 2015 by Guest (see edit history)

[Guest]

Solved

 

This is all about database optimisation

 

I used Vekia's module to clean the database. Loading time of the pages down from 45+ secs to less than 2 seconds

 

WOW

 

Database optimisation needs to be built in!

 

https://www.prestashop.com/forums/topic/275483-module-database-clean-up-optimize-store-db-speed-up-your-store/