Tengel
Posts: 49
|
| Posted: 02/23/2005, 12:05 PM |
|
I try to create a excel file from grind with the code:
Header("Content-type: application/vnd.ms-excel");
Header("Content-Disposition: inline; filename=\"post.xls\"");
This works fine, but my problem comes when my db have like 19000 members, with that many I get time out after 60 sec.
I dont own the server so I can't change the php.ini to fix this, but what I wonder if it is any another way to do this, so I dont get time out?
_________________
---
Tengel |
 |
 |
jeverhart
|
| Posted: 02/23/2005, 2:40 PM |
|
Try using ini_set on max_execution_time. maybe that will work
|
|
|
|
wronco
Posts: 15
|
| Posted: 02/23/2005, 4:36 PM |
|
Alternatively, you could limit the number of rows returned by the query so that it would only return N rows, then alter it to get the next N, etc. etc.
I suppose this would only work if you were trying to get a single copy of your data into excel (ie. not for a page on your website that people are going to request 1000 times a day). OTOH, if you did it once, then the next time(s) you would only have to get the updated rows.
Will
_________________
http://www.willronco.com |
|
|
|
Tengel
Posts: 49
|
| Posted: 02/28/2005, 7:18 PM |
|
Quote jeverhart:
Try using ini_set on max_execution_time. maybe that will work
Thanks, this did work 
_________________
---
Tengel |
|
|
|
James Stone
|
| Posted: 10/09/2007, 2:44 PM |
|
Where is this set?
Have 3000 records, getting timout on Excel
James Stone
jstone@salesnavigator.net
"jeverhart" <jeverhart@forum.codecharge> wrote in message
news:5421d066964a7c@news.codecharge.com...
> Try using ini_set on max_execution_time. maybe that will work
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
wkempees
|
| Posted: 10/09/2007, 3:53 PM |
|
See your other post
Walter
"James Stone" <jstone@salesnavigator.net> schreef in bericht
news:fegsoj$he9$1@news.codecharge.com...
> Where is this set?
> Have 3000 records, getting timout on Excel
>
> James Stone
>jstone@salesnavigator.net
>
> "jeverhart" <jeverhart@forum.codecharge> wrote in message
>news:5421d066964a7c@news.codecharge.com...
>> Try using ini_set on max_execution_time. maybe that will work
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
|
|
