Page 1 of 1
Performance issue, but only when accessing "blog root"
Posted: Fri Feb 03, 2012 8:41 am
by stego
Hi all,
I have a performance issue with my Serendipity, but only when opening the "blog root":
Opening
http://aggrozollhaus.de/blog/index.php
takes
8 seconds,
while opening any "sub page" is pretty fast - even if the dataset is nearly the same.
Opening
http://aggrozollhaus.de/blog/index.php? ... 12/02.html
takes only 2 seconds.
I have no idea what could cause this massive difference since it is the same dataset I'm displaying...
Anybody any ideas?
Thanks,
stego
Re: Performance issue, but only when accessing "blog root"
Posted: Fri Feb 03, 2012 9:22 am
by garvinhicking
Hi!
Which event and sidebar plugins do you have installed? Also strikes me as odd; I'm guessing an event plugin could be interfering when a list of entries is fetched...might be worth to temporarily disable some key event plugins to see what changes things.
Regards,
Garvin
Re: Performance issue, but only when accessing "blog root"
Posted: Fri Feb 03, 2012 10:40 am
by stego
Hello,
even after
- moving all sidebar plugins to be hidden
- moving all event plugins to be inactive
- switching the tamplate to bulletproof
the result is the same.
the root link takes 8 sec, any deeplink is at something like 3 sec...
Or is "hidden" not enought of the sidebar plugins? Do I need to remove them?
Re: Performance issue, but only when accessing "blog root"
Posted: Fri Feb 03, 2012 4:09 pm
by garvinhicking
Hi!
"hidden" is actually okay, those plugins won't be loaded then.
In that case I don't really know how to proceed. You would need to add some timing echo/debug breakpoints within the code of the installation to see. Maybe it's some file operation on the server that is timing out, maybe it's the database with a corrupt table, or missing indexes, or maybe one of the database tables is too large...hard to say, I think full file access to the blog on the server would be needed to further debug this...
Regards,
Garvin
Re: Performance issue, but only when accessing "blog root"
Posted: Fri Feb 03, 2012 5:11 pm
by stego
Hi Garvin,
thanks for your help...!
I have to admitt that the issue is fixed.
Indeed one indexes (unfortunately the one on timestamps of the blog entry table) was not correctly set.
Once after an update I lost all indexes (why ever). I re-added them manually and it looks like I made a mistake with this one.
Now performance is back where it should be.
Best regards,
martin