Jump to content


Photo

IE timeout


  • Please log in to reply
4 replies to this topic

#1 yartax

yartax
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 25 September 2006 - 04:01 PM

Hi,

I have a problem with IE timeout (or any browser). I have a php page that executes a very long stored procedure before show results. The problem is that IE close connection if no receive data within 30 second. I saw that modifying registry it can be raised up to 2 minutes. But my query is more long that 2 minutes and page load fails.

In the php.ini I set maxium execution time for script to 30 minutes. So php is running, but IE has closed connection.


Any idea?
Thanks.

Yartax.

#2 mewhocorrupts

mewhocorrupts
  • Members
  • PipPipPip
  • Advanced Member
  • 36 posts
  • LocationParker, CO

Posted 25 September 2006 - 04:09 PM

Hi,

I have a problem with IE timeout (or any browser). I have a php page that executes a very long stored procedure before show results. The problem is that IE close connection if no receive data within 30 second. I saw that modifying registry it can be raised up to 2 minutes. But my query is more long that 2 minutes and page load fails.

In the php.ini I set maxium execution time for script to 30 minutes. So php is running, but IE has closed connection.


Any idea?
Thanks.

Yartax.


I looked this one up, and PHP had a bug submission for it:
http://bugs.php.net/bug.php?id=27781

They marked it as bogus, since it doesn't happen with any other browser.
-mewhocorrupts

#3 HuggieBear

HuggieBear
  • Members
  • PipPipPip
  • Advanced Member
  • 1,899 posts
  • LocationEngland, UK

Posted 25 September 2006 - 04:17 PM

I have a problem with IE timeout (or any browser).


Was replied with this:

I looked this one up, and PHP had a bug submission for it... They marked it as bogus, since it doesn't happen with any other browser.


I'd say that you've possibly misunderstood something somewhere mewhocorrupts.

yartax, maybe you need to look at why you're code's taking so long to execute as opposed to how to increase the timeout settings.  How long does the query actually take to run when executed in MySQL?

Regards
Huggie
Advice to MySQL users: Get phpMyAdmin and test your queries work there first, take half the hassle out of diagnosis, also check the reserved words list.

Links: PHP Docs :: RegEx's :: MySQL :: DevGuru :: w3schools

#4 mewhocorrupts

mewhocorrupts
  • Members
  • PipPipPip
  • Advanced Member
  • 36 posts
  • LocationParker, CO

Posted 25 September 2006 - 06:27 PM

I have a problem with IE timeout (or any browser).


Was replied with this:

I looked this one up, and PHP had a bug submission for it... They marked it as bogus, since it doesn't happen with any other browser.


I'd say that you've possibly misunderstood something somewhere mewhocorrupts.

yartax, maybe you need to look at why you're code's taking so long to execute as opposed to how to increase the timeout settings.  How long does the query actually take to run when executed in MySQL?

Regards
Huggie


You'd be correct.  Somehow I completely ignored the information in parentheses.  I apologize.
-mewhocorrupts

#5 yartax

yartax
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 26 September 2006 - 08:02 AM

Well, my code is the best it can be.

The problem is that store procedure has to do a lot of calculations. It's a very big database, and I revised the query plan to do the best. Typical is a 2 or 3 minutes time to perform operation.

If php was multithreaded, I can run query while inform to browse some data to not be disconnected, but it is not possible.

Thanks.
Yartax.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users