CODEWITHSUNDEEP
phpmysqlsqldatabase
CKKiller
CKKiller

Reputation: 1422

MySQL Insertions continuing after the script has been closed

I have a script which populates my SQL database with categories from ebay, it sends and recieves xml requests and inserts the data into the database as needed. Since eBay takes a few seconds per request to respond, I had to extend the script's maximum execution time.

After closing the script to change it, the insertions continued, and still are continuing, over 10k entries about now, is there anyway of stopping the database from accepting or processing any more requests from that table? or do I have to wait until it finally stops however long that may be?

Upvotes: 0

Views: 68

Answers (1)

Fenton
Fenton

Reputation: 250942

When you request a page, and then close a window, it doesn't cause the page to stop executing.

It will continue to execute until it completes, times out or gets forcefully terminated.

I suspect you have gone a little overboard with your timeout, so increase it more gradually!

Upvotes: 2

Related Questions