Ich habe in der nurflug_rt alle flüge mit dem toc = 'TVP' und dem provider='IRS' auf den provider provider='TVP' geändert. Verantwortliche: RKU, NFL Zeitpunkt: 17.02.2020, 11:26 - 11:41 Uhr Kunden: LMX Info: ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:26:21] 100000 rows affected in 33 s 711 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 500000 [2020-02-17 11:30:06] 500000 rows affected in 2 m 31 s 937 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:30:59] 100000 rows affected in 37 s 49 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:31:50] 100000 rows affected in 22 s 943 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:32:23] 100000 rows affected in 25 s 352 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:33:04] 100000 rows affected in 25 s 207 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:33:43] 100000 rows affected in 26 s 321 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:34:19] 100000 rows affected in 20 s 694 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:35:08] 100000 rows affected in 20 s 285 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 100000 [2020-02-17 11:36:10] 100000 rows affected in 16 s 52 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 200000 [2020-02-17 11:37:15] 200000 rows affected in 42 s 321 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 200000 [2020-02-17 11:38:28] 200000 rows affected in 53 s 16 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 200000 [2020-02-17 11:39:35] 200000 rows affected in 48 s 816 ms ------------- UPDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 200000 [2020-02-17 11:40:44] 200000 rows affected in 49 s 80 ms ------------- PDATE nurflug_rt set provider='TVP' where toc = 'TVP' and provider='IRS' limit 200000 [2020-02-17 11:41:24] 102182 rows affected in 21 s 83 ms ------------- -- Mit freundlichen Grüßen / Kind regards Rene Kühle - Entwickler - ___________________________________________________________________________ TraSo GmbH Nonnenstraße 42 D-04229 Leipzig Tel.: +49 341 355 740 20 Internet: http://traso.de E-Mail: r.kuehle@traso.de ___________________________________________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig, HRB 21850