Share » Forums » General » Problems with slow admin interface

Problems with slow admin interface

Problems with slow admin interface

Monday 23 August 2004 7:34:07 am - 16 replies

Author Message

Alex Jones

Monday 23 August 2004 10:34:27 am

Ed, how much memory is allocated to PHP? Also, what is the PHP script timeout setting? Both are set in the php.ini.

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Edward Eliot

Tuesday 24 August 2004 5:50:37 am

Alex, thanks for your reply.

I have allocated 32MB to PHP which should be more than enough.

It isn't timing out. The pages do return eventually. PHP max_execution_time is set to 30 seconds although it seems to run beyond this. The longest I have had a page running before returning is 130 seconds.

Alex Jones

Tuesday 24 August 2004 7:01:54 am

Hrrrm, I'm afraid that is a bit beyond my scope - I was hoping for a quick answer for you. Sorry. Perhaps someone else will pop in and help out.

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Neo Backup

Tuesday 24 August 2004 6:16:42 pm

Hey, I have exactly the same problem, except it's even worse. The admin pages take from 90 to 120 secs to generate, but the user page take from 120 to over 180 secs! How come? I have the latest eZpublish version, with enough memory allocated to php etc.
I've just moved to eZpublish because it was plugged to me and I tried it myself and was astounded by the awesome features, but if I have to wait all this time I can't even work. :( Please help?

kracker (the)

The Doctor

Tuesday 24 August 2004 9:52:55 pm

Ed,

It sounds like (and the numbers look like) you don't have all eZ publish cache variables enabled.

Time accumulators:
<snip />
Accumulator Elapsed Percent Count Average
Load cache 0.5689 sec 19.5200% 5 0.1138 sec
Template Total 0.7754 sec 26.6% 1 0.7754 sec
Template load 0.6519 sec 22.3659% 1 0.6519 sec
<snip />
Cache load 0.6178 sec 21.1960% 1 0.6178 sec
Total script time: 2.9145 sec

The eZ Pub runs very responsibly after I followed / created this FAQ:

Configure and Maintain Production Cache with eZ Publish
http://ezpub.co.uk/faqs/development/configure_and_maintain_production_cache_with_ez_publish

It's (currently only) written from the user site perspective but the same settings could easily be placed in your sitestyle_admin/site.ini.append.php

Give it a shot and let us all know about the results.

//kracker
DJ Shadow : The Private Press : Fixed Income

<b>the eZ Pub : http://ezpub.co.uk/</b>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

kracker (the)

The Doctor

Tuesday 24 August 2004 10:01:12 pm

Fyi,

According to Bård Farstad, <i>having MySQL on a separate is not faster with eZ publish</i>, In fact, <i>Having the database on a separate server for databases will be slower due to the overhead in connection time.</i>

<i>But you don't have to take my word for it!</i> -- LeVar Burton (Reading Rainbow):
http://ez.no/community/forum/install_configuration/new_ez_no_servers#msg56571

/kracker
Jello Biafra - Talk on Censorship (spoken word)

<b>the eZ Pub : http://ezpub.co.uk/</b>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

Bård Farstad

Wednesday 25 August 2004 12:00:19 am

Ed,

this sounds very similar to a problem we had recently. For some reason eZ publish figured that it should compile the templates ( atleast some of them ) on every pageload ( unless the page is cached ).

The reason for this was that the time of the server was "older" than the time of the template files. Hence eZ publish thought that the template files were changed and re-compiled the templates. Then on the next page load the template files were still modified in the future compared to the stored compiled templates so a re-compile of the templates was done again. This happens over and over again until the local time of the server catches up with the date/time of the template files.

Please check your server for time skew problems and come back to us so we can write up a FAQ entry for this question. This is a thing which typically can happen when moving an eZ publish installation between servers which are not 100% time synced.

--bård

Documentation: http://ez.no/doc

Edward Eliot

Wednesday 25 August 2004 1:36:51 am

Hello,

Thanks for all your replies, much appreciated. I will try the suggestions made and let you know if any have an effect.

kracker, the settings you talk about look interesting. I will certainly look into these.

kracker, Surely having the database on the same server would be a problem on enterprise level web sites where one needs a distributed architecture for improved performance and stability. I agree it is faster communicating over local disk than 100Mb ethernet but I don't see that adding seconds rather than m/s to the access times. I have worked on sites utilising up to 40 dedicated servers, although not eZpublish, and have never seen such problems.

Bard, the site hasn't been moved between servers. From what I can see the date of the cache files is earlier than the server time. Would there be a problem if there was a difference in time between the web server and database server?

I should reinforce that the problems are mainly to do with the admin interface. The frontend can be sluggish and occasionally pages takes 6 seconds to load but, on the whole, once cached generally only take about a second. First load is a bit of a concern though at up to 130 seconds. It seems a bit much, is this normal?

Great system, btw, I am very impressed. Just need to sort out these speed issues. I am very excited about the opportunities such a system brings, particuarly for my freelance work. I will definately be looking at the professional licenses.

Regards,

Ed.

Bård Farstad

Wednesday 25 August 2004 1:49:41 am

Ed,

the date of the database server should not have anything to do with this.

The time of the first load is heavy the reason for this is the template compilation which is beeing done. I would recommend that you pre-compile all templates for all used site accesses using the command line tool eztc. More information about that can be found here:
http://www.ez.no/ez_publish/documentation/development/scripting/supplied_scripts/template_compiler

Since you're running FreeBSD I should also mention that eZ publish does perform much better on Linux. This is due to that stat calls--file i/o when e.g. files are included in PHP--which is very slow on FreeBSD. When tuning a high performance server for eZ publish we've actually gotten twice the speed from Linux vs FreeBSD in a multi cpu environment. But this slowdown should definetly not be as long as you experience.

--bård

Documentation: http://ez.no/doc

Edward Eliot

Wednesday 25 August 2004 2:04:01 am

Hello,

kracker, I tried the settings and didn't notice any difference.

bard, what you say about FreeBSD is very interesting. I will see if I can locate a Linux box for testing. I will certainly use the template compiling script although my main concern is the admin interface which presumably I cannot use this script for.

Loading the "content" tab takes about 13 seconds. I can post more details if it would be helpful.

Regards,

Ed.

Bård Farstad

Wednesday 25 August 2004 2:57:57 am

Ed, the eztc script works nicely in the admin interface as well. The difference between the admin and website is actually just the templates and permissions, you can e.g. make an intranet with all admin functions on the "user site".

These numbers you are gettins is defenetly what you would expect with the hardware you are running on.

We are also working on improving clustering with eZ publish. We have a project going now to improve the cluster for ez.no which will be added to eZ publish when it's done. For clustering the database we will use MySQL clustering functionality, which means that we will have a local MySQL running on all cluster machines. It will of course handle fail safe situations when servers go down.

--bård

Documentation: http://ez.no/doc

Edward Eliot

Wednesday 25 August 2004 3:09:15 am

Hello,

bard, I have worked out what the problem is and I feel stupid! It seems the hardware isn't what I expected, or was told, it would be. I should have checked this before. Apologies for wasting everybody's time on this.

It turns out the machine was a 400Mhz Zeon with 256MB RAM and the database running on the same server.

I have upgraded this to a 2Ghz Zeon with 2GB RAM and the site is really fast now.

A note to any one else reading this with speed problems, use decent hardware and you won't have any problems.

The points you all raised were very interesting though and may be useful in the future.

Regards,

Ed.

kracker (the)

The Doctor

Wednesday 25 August 2004 3:26:28 am

Don't feel bad Ed,

It happens to the best of us. I like reading your threads & posts :)
I think that besides your specific troubles, several very interesting
subjects were discussed in this thread.

I think that these will be useful to others in the future. Not as
long term as other threads but very topical for the era, every day
we are "making history".

You can't waste my time, only I can do that :)

Regards,
kracker

The Matrix Revolutions : OST : In My Head

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

Edward Eliot

Wednesday 25 August 2004 7:22:52 am

Well, I appreciate the time any way. I plan to be very active in the forum and hopefully I can start contributing useful ideas soon.

Fabricio Guerrero

Tuesday 31 January 2006 11:26:01 am

Hi,

We're having similar issues... we have a real slow load time within the admin interface.. clients complain about the speed issue.

I've got the public facing site cached pretty well.. loads at about 1 sec but the admin interface takes more than 5sec and even worse when you're editing content.

We're having this on 2 different sites and eZ versions... they are: 3.6.0 and 3.6.2

Any ideas on how to further optmize admin site?

Regards,
Fabricio

http://www.solobromasychistes.com <<Joomla Site :P
http://www.recipesforhealthyfood.com/ <<Drupal Site :P
http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...

Thomas Nunninger

Tuesday 31 January 2006 11:47:18 am

Hi Fabricio,

without more information you can't expect the right answer.

- Have you looked at http://ez.no/community/forum/general/ez_speed_optimisation_faq?

- What machine do you have? Dedicated server, shared hosting? RAM?

- How many objects do you have? Do you use SmartCache? Or does eZ wants to delete the whole cache when publishing a new object?

Have a nice evening

Thomas

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu