Re: PHP with MYSQL help with timeout/max execution time error

Police Trainee wrote:

i have a mysql table with approximately 9800 rows and i attempt to use PHP to display the entire table onto a web page. after a few minutes, the page outputs an error indicating maximum execution time of 60 seconds exceeded in ./libraries/display_tbl.lib. I attempted to load mysqld with mysqld -O net_write_timeout=300, however, the value for that variable seems to stay at 60 and does not change to 300. i do not know if this is the source or cause of the problem though as execution time does not sound the same as a write timeout.

As an immediate thought, I'd say you should limit the number of rows you want to show and make it a step by step consultation. Something like 100 rows per page. This has little to do with the timeout problem (10.000 rows should not really take that much time anyway) but it's a user-side consideration. All that stuff is going to make a HUGE page and just kill their browsers, besides, it will take time to deliver that much to a remote user. Now let's see the timeout. AFAIK Apache comes with a 30 seconds limit, so the 60 second thing sounds weird enough. Can you tell me what's your system like? And now to the database. Would you tell us what's the table like and what sort of query are you running against it? Afraid it's hard to answer your question without that stuff :) Alberto Kiev -- @-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@ LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? lOrD i'M sHiNiNg... YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE tHe TeSt, YeS iT iS ThE tEsT, yEs It Is tHe TeSt, YeS iT iS ThE tEsT, yEs It Is.......