Very large dataset file

[home_spun]

All,

I've a very large dataset file which I'm using PHP to dynamically create databases and tables on a MySql server.

My main issue is that the program seems to stall about 15 seconds in.

I ran the program on a 100k dataset file. Worked perfect.

Only the real life dataset it 892 Mb.

Soooooo...... does anyone know what limits on file sizes php can handle?

Any advice / direction would be fantastic.

Cheers,
Home Spun

[theeper]

AFAIK PHP should be able to handle any size file your system can generate, I imagine the issue is time not size. PHP has a max_execution time set in it's config file. By default, I think it is 30 seconds, depending on what you are doing, 30 seconds may not be enough time.

[home_spun]

yup I have said max time value set to 0 which sets it to infinity.

I left it running over night. And it didn't do a spot of work. 🙁