-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Chris wrote: > I've been using a php script which loads a large (approximately > 40,000 records) data file into a mysql table. In the event that > MySql's LOAD DATA INFILE capability is disabled, the script loads > each record individually. The problem I'm facing is trying to run > this script on a server which has safe mode enabled. Under safe > mode the default script execution time is usually 30 seconds, and > to process 40,000 records requires about 2-3 minutes. > > I'm now faced with a situation where I can't load the entire data > file and wondered if anybody else has encountered this problem. > > Also, the following conditions are NOT available as an option. 1 - > use phpmyadmin 2 - increase the script execution time in php.ini > (set_time_limit doesn't work in safe mode) 3 - enable LOAD DATA > INFILE by granting the MySql File_priv > You might make the script recursive, it processes for example 1000 records, then it calls itself to process the next 1000 records, and so on until all the records are processed. You only have to add one post or get variable. - -- Maerlyn maerlyn[AT]citromail[DOT]hu http://putraware.ini.hu GnuPG Public Key ID: 0x0CE0A57 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCVTwDMkyacQzgalcRAo/+AKDXdFsGH8N2xu+CmFM+zdRn+9ZogwCg6skf EWGgp1IyweJiZaz785AYZJU= =+H4V -----END PGP SIGNATURE----- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
