db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Burlison <Alan.Burli...@sun.com>
Subject Re: 'Read timed out' error on update query
Date Tue, 08 Sep 2009 14:28:35 GMT
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
--

Mime
View raw message