0

Hi,

I have a query which takes too long to return result set. After then I turn result set into xls format to be downloaded at same time.

Problem: Obviously, browser says "Request time out". Users will have this problem and my site will fail completely.

What else out there for me to accomplish such thing?

Thanks in advance.

2
Contributors
2
Replies
4
Views
6 Years
Discussion Span
Last Post by veledrom
0

You can try
ini_set('max_execution_time', 0);
at the top of your script. 0 = forever.
and just a thought...
Depending on your query and what type of data you are pulling, can you precompile some of the xml data that you want? As in, run the queries and store the data, and then a user can just request said data.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.