Slow server performance: too many static pages?

T · Post by T » Sat Feb 02, 2008 12:33 am

garvinhicking wrote:So you might need to set an index on the 'pagetitle' columns as well...

OK, this could be it. However, I've temporaly changed my SP-plugin back to the unedited version (so my pages are listed in pageorder) and performance was still as slow as it was before...

Post by **garvinhicking** » Sat Feb 02, 2008 12:15 pm

Hi!

Do you have the temporary possibility to give me FTP access to your installation? This could speed up the whole debugging process a lot.

Regards,
Garvin

T · Post by T » Sat Feb 02, 2008 6:11 pm

garvinhicking wrote:Do you have the temporary possibility to give me FTP access to your installation? This could speed up the whole debugging process a lot.

Yes, I do. I have already created a temporary account for you - where can I send you your login?

Post by **garvinhicking** » Sat Feb 02, 2008 8:12 pm

Hi!

You can send it either here on the forum via PN, or a mail to me on "mail at garv dot in".

Regards,
Garvin

T · Post by T » Sun Feb 03, 2008 1:11 pm

Send it through a PM. Let me know if everything works, and when you find something out.
Thanks,

Post by **garvinhicking** » Sun Feb 03, 2008 2:02 pm

Hi!

Yes, will do. It might take a day or two till I get down to it!

Regards,
Garvin

aludwig99 · Post by **aludwig99** » Thu Mar 13, 2008 5:10 am

I'm having extreme performance problems as well. I have not modded any of the php files and have added no plugins. It takes up to a minute to load the page, and there's only a single entry on the blog.

I have no idea what's causing this. My lack of experience with php makes me think that's somehow related, but I basically just installed the blog and got it working, so I don't know what would be causing it.

Thanks for any help!

Post by **garvinhicking** » Thu Mar 13, 2008 10:09 am

Hi!

In T's case there were simply too many pages in the database, which needed different optimized DB indices.

In your case, how many static pages do you have? Do you even have one? What's your URL? Which event plugins do you have installed?

Regards,
Garvin

aludwig99 · Post by **aludwig99** » Thu Mar 13, 2008 1:43 pm

Hi - when you say static page, are you referring to within the Serendipity directories, or on the server in general? I have created zero additional static pages in the Serendipity directories, and there are only a few on the server in general (no more than 20 or so) which all load very quickly and flawlessly (even when transmitting very, very large pictures). I've installed no event plugins.

Basically, all I've done is install Serendipity, create a second admin userid, and create a single post. The page was loading slow from the very beginning. Is there some kind of log file I can get into that you could examine (I'll probably need detailed instructions if so). Thanks for your help!

Post by **garvinhicking** » Thu Mar 13, 2008 3:42 pm

Hi!

With "Static Pages" I am talking about the Serendipity Static Page plugin.

So i didn't mean any pure HTML pages, but really s9y served pages.

Basically, all I've done is install Serendipity, create a second admin userid, and create a single post. The page was loading slow from the very beginning. Is there some kind of log file I can get into that you could examine (I'll probably need detailed instructions if so). Thanks for your help!

Are you using MySQL? What's your MySQL and PHP versions, what kind of server (hardware) do you run on? This sounds a lot like general performance issues on the server...

Regards,
Garvin

aludwig99 · Post by **aludwig99** » Fri Mar 14, 2008 5:12 am

I was afraid it might be a server issue, which I assume there's not much I can do to fix.

The site is using MySQL 5 and I've used php 4.4.7 and 5 (whatever version), and both cause delays. 5 seems worse, taking about 20 seconds to load, whereas 4 takes about 13, so I'm back on 4 right now. I'm using a cheapo web server running a Debian platform, which I was desperately hoping wasn't the issue (but which I suspect probably is).

Is there anything I can do to tweak performance without changing servers? I didn't realize php would be so taxing - I have been shuttling large amounts of data to and from the server at very good speeds in the past.

Post by **garvinhicking** » Fri Mar 14, 2008 10:15 am

Hi!

Could you maybe try to install a different PHP application on the same server, like Gallery (gallery.sourceforge.net) or osCommerce, or anyother PHP tool that creates some MySQL-DB traffic when being used? This would verify that your server is the troublemaker, and not maybe something else...?

Regards,
Garvin