Thread

Hello,

I have a site http://yorktillyer.com running on Media Temple’s Grid Server - it’s a Freelancer installation of EE 2.5.1 but this issue has existed through all the recent versions of EE@2

It’s not the fastest site, but it behaves pretty much within my expectations other than when I create a new Channel Entry or try to edit a Channel Entry - these two options cause the control panel to stall for many seconds - easily over a minute. I can view the list of Channel entries, it loads quickly, but click on any individual entry and you have to be prepared to wait.

I know there is a feeling that the MT Grid is far from ideal, but I only experience this slowness within the control panel - I can load the relevant page many times whilst the control panel is stalled trying to load the edit window of the same entry, so it does not seem like the server performance is the issue.

Once loded, submitting an entry is not slow - it’s only on load within the control panel that this issue occurs.

Any thoughts would be appreciated.

Many thanks

York

In the admin debug preferences you can turn on the profiler… which will display a bunch of stuff in the footer of pages loaded (only for super admins)

turn it on, go to the page that is lagging, and check out the results below.  There will be a list of queries, take a look at those and see if there are one or more that are taking an excessive amount of time.

this is a good starting point, but there are several paths it may lead you down depending on the results

If I look at the Database Query debug list I see that the longest query took 0.0053 seconds and yet the page took over a minute to load.

The Benchmarks are
Loading Time: Base Classes   0.0426
Total Execution Time   0.8916
Controller Execution Time ( Content Publish / Entry Form )  0.8759

Does this help? I could send you the results in detail if it helps?

thanks

York

Actually that’s wrong, the longest is

0.0135   SELECT *
FROM (`exp_sites`)
WHERE `site_id` =  1

York

wacky.

and this is only happening for specific pages…?
and it’s happening each and every time you do those specific functions (and not others… again, consistently)?

(I’m trying to rule out external forces like “the server resources occasionally run really low and prevent the execution of certain functions… but this would happen on different pages at different times)

I’m very curious to look at your profiler results.  I’ll pm ya.

Hi York,

Nice to see Mark coming in with some solid suggestions! Thanks Mark!

Two big contributing factors to Edit/Publish page loads are Publish Layouts and Channel Fields.

Do you have any publish layouts set for this channel? Are you using a large number of channel fields, or complex channel fields like Matrix, Playa, Channel Images, etc., that could hold the page load with JavaScript or other needs?

I look forward to your reply!

Cheers,

Hello Dan,

Mark actually helped me track down the problem - I’d failed to copy across the third_party theme elements from eehive_flickr a couple of version upgrades ago so on loading the ‘edit’ or ‘create’ entry pages for a channel - the only place these elements were called - the system hung for a while as it tried to load the missing elements. I was fooled by the fact that everything was still working into thinking the poor load of these specific pages was a more complex issue than it turned out to be.

Mark’s help was excellent and my instillation is now working nicely.

Many thanks

York

Hey York,

Glad to hear it!!!

The community here is like no other. They rock!

If you need anything else, please just let me know by opening a new thread.

Cheers,