There are some set_time_limit() in phpMyAdmin, but I don't think this is my problem, because I get an error after 3 seconds.
Without the patch, I get my dump at the screen in 7 seconds.
Maybe I hit a memory limit in my PHP configuration.
BTW, set_time_limit() does not work when PHP is in safe mode, a user suggests in the PHP manual to do this:
if (! get_cfg_var('safe_mode')) { set_time_limit(180); }
Marc
jeremy brand a écrit :
Howdy all,
I wonder if the timeout is (since the gziping takes time -- presumably more time) that maybe we have reached our set_time_limit() (default in php.ini of 30 seconds).
I thought about this when I was writing it, but it didn't seem to be an issue specifically of doing gzip compression. I think this may be a separate issue that this patch has discovered.
Anyone know if set_time_limit() is set anywhere in phpMyAdmin? If so, on big dumps it should be set to set_time_limit(0) [indefinate] because you never know how long it will take to send the data.
Jeremy
On Fri, 20 Jul 2001, the following spilled from the mind of Marc Delisle:
Date: Fri, 20 Jul 2001 09:41:34 -0400 From: Marc Delisle DelislMa@CollegeSherbrooke.qc.ca Reply-To: phpmyadmin-devel@lists.sourceforge.net To: phpmyadmin-devel@lists.sourceforge.net Subject: Re: [Phpmyadmin-devel] Gzip HTTP Content-Encoding patch
When I try to dump a 5 MB table to screen (I know, not very efficient...), with the Content-Encoding patch, it eventually times out with "document contains no data".
This is with NN4. Without the patch, I get the dump on screen.
Apart from this glitch, the patch looks great and is a real speed improvement!
Should I commit it in cvs, with maybe an additional entry in the FAQ about this dump problem?
Marc Delisle a écrit :
Ok thanks Jeremy,
I am testing your patches.
Marc
jeremy brand a écrit :
Hello Tobias (and others),
I've got board and decided to check up on this probject. I was looking at the feature request page on the sourceforge project and decided to whip this out as I have just done a similar upgrade on my own web site and have seen enourmous speed increase from the site.