is my PHP timing out?

jvanv8

I have a PHP script which also connects to mysql which parses image URLS (read from mysql) and returns the width and height of the image using:
getimagesize($imageURL);

It seems to take forever even for 25 images. It will output the width of each image if I only check 25 image urls but if I try to do 50 it "processes" forever then just seems to quit with no output.

So, is this PHP timing out, mySQL timing out, Apache timing out (running on localhost here), the browser timing out or....????

Very confused. The only option I can see is to run the script for 25 images then just use javascript or a redirect to open another page to read images 26-50 then another for 51-75 ... etc, etc..

Thanks for any help!
John

micmac

Hi,
You could try

ini_set("max_execution_time", 1000000);

where 1000000 is in reference to the seconds passed.
However, if your script is written correctly you will not need the above. It might be an idea to post your script.

jvanv8

Ok, here it is... the first loop just grabs the image urls from a database such as "http://www.other-guys-site.com/images/image1.jpg"

<?php
 	include("dbinfo.inc.php");
	/** Current attempts to prevent timeout if it is the issue */
	//set_time_limit(0);
	ini_set("max_execution_time", 1000000);


$query = "SELECT product_id, product_image, image_display 
           FROM product_image 
           WHERE product_image LIKE 'http%' LIMIT 50";
$result = mysql_query($query);

for($i=0; $row = mysql_fetch_array($result); $i++){
	$image_array[$i]['image'] = $row['product_image'];
	$image_array[$i]['product_id'] = $row['product_id'];
	$image_array[$i]['image_display'] = $row['image_display'];
}

for($j=0;$j<count($image_array);$j++){
	$img_attributes = getimagesize($image_array[$j]['image']);
	$width = $img_attributes[0];
	print("The width is $width<br/>");
	if($width <= 1){
        /* deal with 1 px image here */
	    print("A 1 px image was found<br/>");
	}

}	

?>

If I set the LIMIT on the mysql to 25 it works (after a long while) but if its at 50 (as it is above) nothing is outputted. The database output is correct and $image_array[$j]['image'] indeed contains a valid url of an image on another server.
John

jvanv8

I just timed it and the script stopped after exactly 5 minutes or 300 seconds for getting the widths of 50 images.

jvanv8

I thought I adjusted the 300 second limitation in my httpd.conf file but it turns out that there was another httpd.conf file that listed the max timeout at 300 seconds. Adjusting it to a bigger number fixed the problem.

But still... that getimagesize() function is REALLY slow. It took just over 8 MINUTES to get the widths of 50 images. I can't wait to see how long it will take to process 10,000 images :eek:

John

Weedpacket

You can try playing with [man]set_time_limit[/man]; if you use that inside the loop to set a time limit that would be reasonable for one image, you oughtn't need to worry about how many images there are.

Certainly it makes more sense than just setting the maximum timeout to eleven days - what if something hanged? You wouldn't find out for nearly two weeks.

One other suggestion for speeding up the whole thing: if those images are files stored on your local machine (and not all over the web or dynamically generated, as implied by your using URLs), then you would get much better performance referring to them by filename instead of by URL because then you won't be adding the extra step of asking your web server for the file.