I need an alternative to set_time_limit

[btray77]

I need to do something other than use set_time_limit(); 

 

I still get timeouts on huge database imports.  (Command line is not available, and the data feed is not a standard format, so there is no real way of doing mysql's CSV or XML import command)

 

I am importing about 100,000 products, and images from a datafeed.  I have NO problems if I don't have to download the images, but the time that it takes to download the images causes the system to timeout.  (and it's not from a browser timeout issue, I've got it sending data to the screen each time it does an action)

 

 

I was thinking about possibly using ajax to call the script to run 1 query at a time, but I'm not sure how to do this. 

 

1. Anyone know of a tutorial on something like this?  (I have jquery loaded)

2. If this is not a "good" way, can you give me an idea of how you would do this?

 

Thank you

 

-Brad

[Mchl]

And why do you need an alternative? Does it not work as expected?

[btray77]

No as I had said, It times out... 

 

I'm guessing I need something that uses Ajax to re-request the script do something...

 

-Brad

[Garethp]

Here

 

http://www.w3schools.com/Ajax/Default.Asp

 

It's actually quite simple, you could learn it in half an hour

[chaiwei]

If you just want to import sql file to mysql database,

try bigdump.

 

You need to upload the sql file to your server.

then configure the username, pwd, host and the database name that in the script.

 

It is useful to import large database file.

Last time I was using phpmyadmin to import but it fails, so I switch to bigdump now.