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
Performance issue, but only when accessing "blog root"
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Performance issue, but only when accessing "blog root"
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: Performance issue, but only when accessing "blog root"
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?
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?
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Performance issue, but only when accessing "blog root"
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
"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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: Performance issue, but only when accessing "blog root"
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
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