php.exe hogs CPU

mystix

Joined: 2005-03-23
Posts: 11
Posted: Wed, 2005-03-23 18:14

Hi all!

I'm having some performance problems, when my gallery page loads in my browser, php.exe on the server jumps to max CPU usage and it takes nearly 30 seconds to load the initial page with 18 thumbnails from the gallery. Which I feel is pretty slow... asked a friend to access the page at the same time as me and then I got "Fatal error: Maximum execution time of 30 seconds exceeded in C:\_web\Gallery2Beta\cache\entity\7\4\742.inc on line 1"

After some searching I thought running BuildAllDerivatives.php might solve this problem, but sadly it was just as slow afterwards. I then started looking for some php accelerator, but I can't manage to find a freeware one for Windows/IIS.

The specs for the server is Celeron 2.4GHz 384MB memory
----

Gallery URL (optional):
Gallery version: G2 beta 1
Webserver (with version): IIS6
Datatabase (with version): mysql 4.0.24
PHP version (eg 4.2.1): 4.3.8
phpinfo URL (optional):
Graphics Toolkit(s): ImageMagick 6.2.0
Operating system: Windows 2003 Standard Edition
Web browser/version: Opera 7.54 / IE 6.0
G1 version (for migration bugs):
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-03-23 20:42

that shouldn't be the case for a computer like yours.

how many users/albums/items do you have? how big are these items (size in kb/mb)? what kind of file types (bmp, tiff, jpg, ...)?

i guess it's a strange php build. what kind of experience do you have with windows 2003 (server?), IIS and php ?
 
mystix

Joined: 2005-03-23
Posts: 11
Posted: Wed, 2005-03-23 20:59

The total number of users created is 33, there's 56 albums and 2120 items in total. Only one kind of files, jpg, all which are 1280pixels at the longest side.

I've got pretty good experience with windows 2003 server, some experience with IIS, but very little with php... :(
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-03-23 21:03

thanks. my questions regarding experience was headed in a different direction. did you already run php-database applications on your IIS/php/windows 2003 setup? did you have no performance problems?
and do you get this performance problems for a single concurrent request?

can we access the G2 or the phpinfo page of this server?
 
mystix

Joined: 2005-03-23
Posts: 11
Posted: Wed, 2005-03-23 21:36

I installed this server fresh yesterday, nothing else was running on it, it is dedicated to hosting the gallery.

I'll pm you the url and user/passord.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-03-23 21:48

@mindless:
Your webserver does not support localization. Please instruct your system administrator to reconfigure PHP with the gettext option enabled. that has no influence on the performance, right?

@mystix: could you create a phpinfo.php file <?php phpinfo(); ?> in your webroot such that i can access it via the webbrowser?

my guess is that it has not much to do with G2. I guess your setup is uncommon, perhaps buggy. and some strange bug results in this poor performance.
apache2/php5 is a quite common and stable setup.
 
mystix

Joined: 2005-03-23
Posts: 11
Posted: Wed, 2005-03-23 21:55

I've created that file now.

Ok, guess I'll spend the night configuring that then :wink:
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-03-23 22:08

hmm, i just have no experience with IIS. perhaps you can stick with IIS, take a look at http://www.webservertalk.com/message948495.html and other google hits.

but the performance you experience is definitely a lot slower than G2 should be on a system with the described specs.
 
mystix

Joined: 2005-03-23
Posts: 11
Posted: Thu, 2005-03-24 14:30

I tried configuring using ISAPI instead, but all that it did was w3wp.exe using 100% CPU instead.

Uninstalled IIS and installed Apache2, then apache.exe was using 100% CPU and the gallery was still as slow.

So I gave up and installed IIS and gallery 1.5 RC2 which now works fast and with low CPU usage :)