script optimization

[nilamo]

Also, if the table(s) have indexes, it can be beneficial to delete the indexes while inserting/updating many rows, and then readding the index when done. Otherwise, the db rebuilds the index at each update, making it very slow.