Thread

I’m trying to figure out why my site is running so slow. Before recently switching over to a newer and better server, everything seems VERY sluggish. It seems that every time I try to save something to the database it takes 15 seconds…every time (longer if uploading a file). What’s also weird, is that while I’m waiting for the change to be save, i’ll go and refresh the website I’m making a change to and the change is there before ee even has a chance to finish saving. Somewhere this code is getting held up. On the old server everything worked fine (1-3 second load), the only thing we changed in the code was the domain name. At the bottom of my ee page it is telling me that it took 11 seconds for the script to load:

————————————————————
ExpressionEngine 1.6.8 - © Copyright 2003 - 2010 - EllisLab, Inc.
Script executed in 11.3902 seconds   15 SQL queries used
Build:  20100121

There may be a new version of EE out there but we are going to remain on this version as this is an old site that we are gradually fading out.
————————————————————

SERVER INFO
======================
MediaTemple 4.0
Memory: 2GB
Disk: 100GB
xfer: 2TB
======================

I also have a few SAEF’s and am seeing the same results. I’ve tried using the template debugging but don’e see anything that slaps me in the face:

TEMPLATE DEBUGGING
(0.000011) - Begin Template Processing -
(0.000444) URI: /home/
(0.000458) Path.php Template: /
(0.000472) Retrieving Template
(0.000483) Parsing Template URI
(0.000733) Retrieving Template from Database: home/index
(0.001207) Template Found
(0.001224) Determining Template Access Privileges
(0.002372) Template Type: webpage
(0.002489) Parsing Site Variables
(0.002526) Global Path.php Variables (Keys): site_id|site_label|site_short_name
(0.002537) Global Path.php Variables (Values): 11|Project Factory|projectfactory
(0.002599) Parse Date Format String Constants
(0.002618) Parse Current Time Variables
(0.002647) Parsing Segment, Embed, and Global Vars Conditionals
(0.007645) - Beginning Tag Processing -
(0.007670) - End Tag Processing -
(0.007766) - Processing Sub Templates (Depth: 1) -
(0.007791)    List of Embeds: embed/.html_header,embed/.navigation,embed/.footer
(0.007843)    Processing Sub Template: embed/.html_header
(0.007860)    Retrieving Template
(0.007875)    Retrieving Template from Database: embed/.html_header
(0.008486)    Template Found
(0.008706)    Template Type: webpage
(0.008814)    Parsing Site Variables
(0.008869)    Global Path.php Variables (Keys): site_id|site_label|site_short_name
(0.008893)    Global Path.php Variables (Values): 11|Project Factory|projectfactory
(0.008971)    Parse Date Format String Constants
(0.008992)    Parse Current Time Variables
(0.009027)    Parsing Segment, Embed, and Global Vars Conditionals
(0.009302)    - Beginning Tag Processing -
(0.009318)    - End Tag Processing -
(0.009352)    Processing Advanced Conditionals
(0.009751)    - Processing Sub Templates (Depth: 2) -
(0.009773)        List of Embeds: embed/.scripts
(0.009819)        Processing Sub Template: embed/.scripts
(0.009835)        Retrieving Template
(0.009850)        Retrieving Template from Database: embed/.scripts
(0.010393)        Template Found
(0.010963)        Template Type: webpage
(0.011084)        Parsing Site Variables
(0.011120)        Global Path.php Variables (Keys): site_id|site_label|site_short_name
(0.011133)        Global Path.php Variables (Values): 11|Project Factory|projectfactory
(0.011203)        Parse Date Format String Constants
(0.011224)        Parse Current Time Variables
(0.011307)        Parsing Segment, Embed, and Global Vars Conditionals
(0.011391)        - Beginning Tag Processing -
(0.011407)        - End Tag Processing -
(0.011516)    Processing Sub Template: embed/.navigation
(0.011534)    Retrieving Template
(0.011548)    Retrieving Template from Database: embed/.navigation
(0.012122)    Template Found
(0.012380)    Template Type: webpage
(0.012496)    Parsing Site Variables
(0.012530)    Global Path.php Variables (Keys): site_id|site_label|site_short_name
(0.012542)    Global Path.php Variables (Values): 11|Project Factory|projectfactory
(0.012634)    Parse Date Format String Constants
(0.012667)    Parse Current Time Variables
(0.012702)    Parsing Segment, Embed, and Global Vars Conditionals
(0.013339)    - Beginning Tag Processing -
(0.013365)    - End Tag Processing -
(0.013400)    Processing Advanced Conditionals
(0.013996)    Processing Sub Template: embed/.footer
(0.014016)    Retrieving Template
(0.014031)    Retrieving Template from Database: embed/.footer
(0.014586)    Template Found
(0.014699)    Template Type: webpage
(0.014801)    Parsing Site Variables
(0.014837)    Global Path.php Variables (Keys): site_id|site_label|site_short_name
(0.014849)    Global Path.php Variables (Values): 11|Project Factory|projectfactory
(0.014891)    Parse Date Format String Constants
(0.014907)    Parse Current Time Variables
(0.014927)    Parsing Segment, Embed, and Global Vars Conditionals
(0.014964)    - Beginning Tag Processing -
(0.014976)    - End Tag Processing -
(0.015033) - End Template Processing -
(0.015042) Parse Global Variables
(0.017523) Template Parsing Finished
Memory Usage: 6,236,576 bytes

It’s more than likely MediaTemple itself. Are you on a GS plan, or what exactly?

No, DV 4.0 with 2GB of memory, 100GB disk space and 2TB xfr… should be more than enough to run EE. I am also running another instance of EE 2.0 on a sub domain off the same server and the instance is working fine. I’ve also ran EE on other MT servers before without a problem. The slowness is only when trying to make changes to the database via custom fields. Changes to setting in the cp go quickly enough.

I am working with a server specialist that has also tried a few tweaks to the server itself but that has not worked. I’m only at about 30% usage on the server.

I’ve also tried to remove all plugins, modules and extensions but that still didn’t help

LCBC Church,

How much PHP memory do you have?

In your Output and Debugging Preferences do you have Generate HTTP Page Headers? and Enable GZIP Output? turned on?

Switch off the template debugging and turn on the Display SQL Queries?. That should giv a more accurate reading as to where there may be a bottleneck.

On the old server everything worked fine (1-3 second load), the only thing we changed in the code was the domain name.

I have to ask but obviously that is not literally? You hooked up the config file to your new database and changed all the paths to reflect new server right?

Check your file permissions for your cache folder are set to 777

Are you doing any database caching from within EE?

Hey John - I appreciate you thinking this through with me. Turns out it was the permissions on the cache folder we not set correctly, thanks for setting me straight. Load times are great now, 1-3 seconds per load. Thanks!

Just in case anyone else is having the same problems, I have attached my answers to your questions. Thanks for the help, feel free to close the ticket!

=================================

Currently PHP Memory is set at 8mb with the ability to go higher if need be.

I currently have both HTTP Page Headers and GZIP Output enabled. I tried turning them off as well but the site was still slow so they are back on.

The SQL Queries don’t look out of the norm to me. Remember that the slowness I am seeing is both on the control panel and the front end of the site. This is also happening across sites (We have MSM 8-10 sites), across weblogs, across all custom and default fields.

Yes, we did all the things necessary to transfer the site over.

No DB caching.

================================

I am very glad to see that you were able to solve this! Please post again as needed.