Alan Burlison wrote:
I'm trying to do a large update, and after about 15 seconds the update statement fails with the following error:
If I recode the update as the equivalent set of updates: update users_to_collectives set relationship_type_id = 13 where relationship_type_id = 12; update users_to_collectives set relationship_type_id = 12 where relationship_type_id = 11; update users_to_collectives set relationship_type_id = 11 where relationship_type_id = 10; update users_to_collectives set relationship_type_id = 10 where relationship_type_id = 9; update users_to_collectives set relationship_type_id = 9 where relationship_type_id = 8; update users_to_collectives set relationship_type_id = 8 where relationship_type_id = 7; update users_to_collectives set relationship_type_id = 7 where relationship_type_id = 6; update users_to_collectives set relationship_type_id = 6 where relationship_type_id = 5; update users_to_collectives set relationship_type_id = 5 where relationship_type_id = 4; I see the following timings: 406 Row(s) Updated Query 10 of 19 elapsed time (seconds) - Total: 0.793, SQL query: 0.793 2 Row(s) Updated Query 11 of 19 elapsed time (seconds) - Total: 0.015, SQL query: 0.015 799 Row(s) Updated Query 12 of 19 elapsed time (seconds) - Total: 1.952, SQL query: 1.952 989 Row(s) Updated Query 13 of 19 elapsed time (seconds) - Total: 2.905, SQL query: 2.905 106 Row(s) Updated Query 14 of 19 elapsed time (seconds) - Total: 0.072, SQL query: 0.072 4,677 Row(s) Updated Query 15 of 19 elapsed time (seconds) - Total: 61.596, SQL query: 61.596 789 Row(s) Updated Query 16 of 19 elapsed time (seconds) - Total: 1.828, SQL query: 1.828 889 Row(s) Updated Query 17 of 19 elapsed time (seconds) - Total: 2.374, SQL query: 2.374 4,300 Row(s) Updated Query 18 of 19 elapsed time (seconds) - Total: 47.398, SQL query: 7.398 -- Alan Burlison --
