btray77 Posted October 13, 2009 Share Posted October 13, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/177515-i-need-an-alternative-to-set_time_limit/ Share on other sites More sharing options...
Mchl Posted October 13, 2009 Share Posted October 13, 2009 And why do you need an alternative? Does it not work as expected? Quote Link to comment https://forums.phpfreaks.com/topic/177515-i-need-an-alternative-to-set_time_limit/#findComment-935942 Share on other sites More sharing options...
btray77 Posted October 13, 2009 Author Share Posted October 13, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/177515-i-need-an-alternative-to-set_time_limit/#findComment-935944 Share on other sites More sharing options...
Garethp Posted October 13, 2009 Share Posted October 13, 2009 Here http://www.w3schools.com/Ajax/Default.Asp It's actually quite simple, you could learn it in half an hour Quote Link to comment https://forums.phpfreaks.com/topic/177515-i-need-an-alternative-to-set_time_limit/#findComment-935950 Share on other sites More sharing options...
chaiwei Posted October 13, 2009 Share Posted October 13, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/177515-i-need-an-alternative-to-set_time_limit/#findComment-935955 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.