Problems with slow admin interface

Monday 23 August 2004 7:34:07 am

I am developing a site in eZpublish 3.4 and am having problems with a very slow admin interface. Page load times are 10 - 20 seconds and editing and saving can be even longer.

I don't have so many problems on the front end with cached page times 1 - 2 seconds, although first loading of a page is in the region of 30 - 50 seconds.

The site is very simple with only 10s rather than 100s of objects and very minimal template code. No decision logic or loops.

Here is the debug information for a cached page on the front end:

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Module start 'content' 0.0000 sec 1.8465 sec 0.0000KB 0.0000KB
Module end 'content' 1.8465 sec 0.7834 sec 0.0000KB 0.0000KB
End 2.6300 sec 0.0000KB 0.0000KB
Total runtime: 2.6312 sec

Time accumulators:
Accumulator Elapsed Percent Count Average
Mysql Total
Mysql_queries 0.0104 sec 0.3561% 3 0.0035 sec
Looping result 0.0016 sec 0.0543% 3 0.0005 sec
ini_load
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
Template processing 0.1217 sec 4.1755% 1 0.1217 sec
override
Cache load 0.6178 sec 21.1960% 1 0.6178 sec
Total script time: 2.9145 sec

The site is running on 2 rackmount servers with the first hosting eZpublish and the second the MySQL database. Both servers are high spec, at least 2Ghz Pentium, 2GB RAM and mirrored hard disks. Running FreeBSD.

Any ideas would be greatly appreciated.

Regards,

Ed.

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.

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?

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/

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.

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.

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.

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.

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