Page tree

Patches exklusiv ab Branch 8.20 (8.8.20.0 RC 15 - 13.04.2017  16:30):

Patch

Zeitintensive Tabellen                                                                             

Geschätze Dauer bei größerer Kunden-DBDatumVersion
1269addresses2 - 3 Minuten07.05.2021Next
1268-0,5 Minuten06.05.2021Next
1267trip_waypoints10 Minuten04.05.2021Next
1266tariff_positions (viele Tarifpositionen)4 - 6 Minuten03.05.2021Next
1265-0,5 Minuten03.05.2021Next
1264

container_import_orders

package_import_orders

2 - 3 Minuten

1 - 2 Minuten

29.04.2021Next
1263-0,1 Minuten29.04.2021Next
1262-0,5 Minuten27.04.2021Next
1261-0,1 Minuten27.04.2021Next
1260-0,1 Minuten27.04.2021Next
1259-0,1 Minuten26.04.2021Next
1258-0,1 Minuten26.04.2021Next
1257-0,1 Minuten23.04.2021Next
1256-0,1 Minuten22.04.2021Next
1255-0,1 Minuten22.04.2021Next
1254-0,1 Minuten22.04.2021Next
1253package_import_waypoints1 - 2 Minuten21.04.2021Next
1252-0,5 Minuten21.04.2021Next
1251container_import_orders2 - 3 Minuten21.04.2021Next
1250-0,1 Minuten19.04.2021Next
1249tariff_positions1 Minuten16.04.2021Next
1248-0,5 Minuten16.04.2021Next
1247-0,5 Minuten16.04.2021Next
1246-0,1 Minuten15.04.2021Next
1245-0,1 Minuten12.04.2021Next
1244-0,1 Minuten12.04.2021Next
1243transport_packages2 - 3 Minuten12.04.2021Next
1242-0,1 Minuten12.04.2021Next
1241-0,5 Minuten12.04.2021Next
1240-0,1 Minuten09.04.2021Next
1239

volvo_import_orders

volvo_import_order_cargo_contents

base_order_cargo_contents

1 - 2 Minuten

2 - 3 Minuten

4 - 5 Minuten

30.03.2021Next
1238trips10 - 15 Minuten29.03.2021Next
1237

package_import_orders

container_import_orders

1 Minute

1 Minute

24.03.2021Next
1236-0,5 Minuten24.03.2021Next
Patches für MySQL-Connector-Update - Ende
1235-0,5 Minuten24.03.2021Next
1234-0,5 Minuten24.03.2021Next
1233-1 Minute24.03.2021Next
1232-0,5 Minuten24.03.2021Next
1231

orders  (ALGORITHM=INPLACE)

trips  (ALGORITHM=INPLACE)

waypoints

1 Minuten

1 Minuten

10 - 15 Minuten

24.03.2021Next
1230

status_history  (ALGORITHM=INPLACE)

waypoint_activity

waypoint_time_restriction  (ALGORITHM=INPLACE)

1 Minute

5 - 6 Minuten

1 Minute

24.03.2021Next
1229-1 Minute24.03.2021Next
1228

accounting_blocks (ALGORITHM=INPLACE)

accounting_positions (ALGORITHM=INPLACE)

billing_positions (ALGORITHM=INPLACE)

ilv_data (ALGORITHM=INPLACE)

1 Minute

1 Minute

1 Minute

1 Minute

24.03.2021Next
1227-2 Minuten24.03.2021Next
1226-1 Minute24.03.2021Next
1225-1 Minute24.03.2021Next
1224-1 Minute24.03.2021Next
1223-0,5 Minuten24.03.2021Next
1222-3 Minuten24.03.2021Next
1221

addresses (ALGORITHM=INPLACE)

address_mandator_information (ALGORITHM=INPLACE)

1 Minute

1 Minute

24.03.2021Next
1220tariff_positions (viele Tarifpositionen)4 - 6 Minuten24.03.2021Next
Patches für MySQL-Connector-Update - Start
1219-0.1 Minuten24.03.2021Next
1218-0.1 Minuten19.03.2021Next
1217-0.1 Minuten19.03.2021Next
1216trips10 - 15 Minuten19.03.2021Next
1215

package_import_packages

transport_packages

2 - 3 Minuten

2 - 3 Minuten

19.03.2021Next
1214-0.1 Minuten19.03.2021Next
1213-0.1 Minuten16.03.2021Next
1212package_import_orders1 Minute16.03.2021Next
1211-0.1 Minuten15.03.2021Next
1210-0.1 Minuten15.03.2021Next
1209-0.1 Minuten08.03.2021Next
1208-0.1 Minuten08.03.2021Next
1207-0.1 Minuten08.03.2021Next
1206-0.1 Minuten08.03.2021Next
1205trips10 - 15 Minuten04.03.2021Next
1204tariff_positions (viele Tarifpositionen)4 - 6 Minuten04.03.2021Next
1203-0.1 Minuten01.03.2021Next
1202-0.1 Minuten01.03.2021Next
1201

trips  (+ neuer Index)

20 - 30 Minuten

26.02.2021Next
1200-0.1 Minuten24.02.2021Next
1199-0.1 Minuten24.02.2021Next
1198-0.1 Minuten23.02.2021Next
1197checklist0,5 Minuten23.02.2021Next
1196-0,5 Minuten22.02.2021Next
1195
0.1 Minuten19.02.2021Next
1194-0,2 Minuten19.02.2021Next
1193waypoint_cargo_contents (+ neuer Index)8 - 10 Minuten19.02.2021Next
1192-0,5 Minuten19.02.2021Next
1191package_status_history1 Minute19.02.2021Next
1190
0,5 Minuten16.02.2021Next
1189
0.1 Minuten11.02.2021Next
1188
0,1 Minuten10.02.2021Next
1187-0,5 Minuten08.02.21Next
1186-0,5 Minuten08.02.21Next
1185-0,5 Minuten05.02.2021Next
1184-0,5 Minuten05.02.2021Next
1183trip_documents1 Minute05.02.2021Next
1182-0,5 Minuten01.02.2021Next
1181orders8 - 10 Minuten01.02.2021Next
1180tours5 Minuten01.02.2021Next
1179-0,5 Minuten01.02.2021Next
1178-0,5 Minuten29.01.2021Next
1177-0,5 Minuten29.01.2021Next
1176-0,5 Minuten27.01.2021Next
1175-0,5 Minuten27.01.2021Next
1174addresses2 - 3 Minuten27.01.2021Next
1173-0,5 Minuten26.01.2021Next
1172-0,5 Minuten26.01.2021Next
1171

container_import_dangerous_goods

package_import_dangerous_goods

1 Minute

1 Minute

21.01.2021Next
1170-0,5 Minuten21.01.2021Next
1169package_import_orders1 Minute21.01.2021Next
1168-1 Minuten19.01.2021Next
1167`waypoints` (Update - Befehl, keine Schema-Änderung)4 - 6 Minuten19.01.2021Next
1166-0,5 Minuten18.01.2021Next
1165-0,5 Minuten15.01.2021Next
1164-0,5 Minuten14.01.2021Next
1163-0,5 Minuten14.01.2021Next
1162trip_documents1 Minute12.01.2021Next
1161-0,5 Minuten12.01.2021Next
1160`locating_history` (Ortungshistorie)2 - 3 Minuten12.01.2021Next
1159-0,5 Minuten12.01.2021Next
1158-0,5 Minuten12.01.2021Next
1157order_missing_data1 Minute12.01.2021Next
1156-0,5 Minuten12.01.2021Next
1155tariff_positions (viele Tarifpositionen)4 - 6 Minuten07.01.2021Next
1154-0,5 Minuten07.01.2021Next
1153-0,5 Minuten17.12.2020Next
1152-0,5 Minuten17.12.2020Next
1151-0,5 Minuten17.12.2020Next
1150

package_import_waypoints

package_export_waypoints

1 Minute

1 Minute

11.12.2020Next
1149

package_import_waypoints

package_export_waypoints

1 Minute

1 Minute

10.12.2020Next
1148orders8 - 10 Minuten08.12.2020Next
1147-0,5 Minuten07.12.2020Next
1146-0,5 Minuten07.12.2020Next
1145-0,5 Minuten07.12.2020Next
1144

base_order_cargo_contents

transport_packages

package_import_packages

4 - 5 Minuten

2 - 3 Minuten

2 - 3 Minuten

03.12.2020Next
1143-0,5 Minuten03.12.2020Next
1142-0,5 Minuten02.12.2020Next
1141`tariff_positions` (viele Tarifpositionen)3 - 5 Minuten02.12.2020Next
1140-0,5 Minuten02.12.2020Next
1139-0,5 Minuten02.12.2020Next
1138

orders

trips

8 - 10 Minuten

10 - 15 Minuten

30.11.2020Next
1137

container_import_orders

package_import_orders

1 Minute

1 Minute

26,11.2020Next
1136-0,5 Minuten24.11.2020Next
1135-0,5 Minuten24.11.2020Next
1134-0,5 Minuten24.11.2020Next
1133-0,5 Minuten24.11.2020Next
1132-0,5 Minuten24.11.2020Next
1131-0,5 Minuten20.11.2020Next
1130-0,5 Minuten17.11.2020Next
1129-0,5 Minuten17.11.2020Next
1128-0,5 Minuten16.11.2020Next
1127-0,5 Minuten12.11.2020Next
1126(UPDATE Befehl für order_state_history und orders)3 Minuten12.11.2020Next
1125-0,5 Minuten09.11.2020Next
1124-0,5 Minuten04.11.2020Next
1123-0,5 Minuten04.11.2020Next
1122-0,5 Minuten04.11.2020Next
1121-0,5 Minuten04.11.2020Next
1120-0,5 Minuten03.11.2020Next
1119-0,5 Minuten03.11.2020Next
1118

`orders`

`base_order_cargo_contents`

6 - 8 Minuten

4 - 5 Minuten

03.11.2020Next
1117-0,5 Minuten03.11.2020Next
1116`tariff_positions` (viele Tarifpositionen)3 - 5 Minuten03.11.2020Next
1115-0,5 Minuten29.10.2020
1114-0,5 Minuten27.10.2020
1113-0,5 Minuten27.10.2020
1112-0,5 Minuten27.10.2020
1111`trips`10 - 15 Minuten21.10.2020
1110-0,5 Minuten14.10.2020
1109-0,5 Minuten09.10.2020
1108-0,5 Minuten08.10.2020
1107-0,5 Minuten08.10.2020
1106-0,5 Minuten08.10.2020
1105-0,5 Minuten07.10.2020
1104-0,5 Minuten07.10.2020
1103-0,5 Minuten05.10.2020
1102

`orders`

`tariff_positions` (viele Tarifpositionen)

6 - 8 Minuten

3 - 5 Minuten

01.10.2020
1101-0,5 Minuten01.10.2020
1100-0,5 Minuten25.09.2020
1099-0,5 Minuten24.09.2020
1098-0,5 Minuten24.09.2020
1097-0,5 Minuten23.09.2020
1096-0,5 Minuten23.09.2020
1095-0,5 Minuten23.09.2020
1094-0,5 Minuten23.09.2020
1093`no_shows`1 Minute21.09.2020
1092-0,5 Minuten18.09.2020
1091

`status_requests` (TR02)

`transport_booking_state_log

4 - 5 Minuten

10 - 15 Minuten

17.09.2020
1090-0,5 Minuten17.09.2020
1089-0,5 Minuten17.09.2020
1088-0,5 Minuten16.09.2020
1087`no_shows`1 Minute04.09.2020
1086-1 - 2 Minuten21.08.2020
1085`transport_bookings`4 - 5 Minuten19.08.2020
1084`tariff_positions` (viele Tarifpositionen)3 - 5 Minuten14.08.2020
1083-1 - 2 Minuten22.07.2020
1082`accounting_blocks`10 - 15 Minuten15.07.2020
1081-1 - 2 Minuten08.07.2020
1080-1 - 2 Minuten01.07.20209.30.0.16
1079-1 - 2 Minuten30.06.20209.30.15.0
1078-1 - 2 Minuten26.06.20209.30.12.0
1077

`waypoint_activity`

`status_requests` (2 Durchläufe)

`transport_booking_state_log`

4 - 5 Minuten

8 - 10 Minuten

10 - 15 Minuten

24.06.20209.30.10.0
1076

`order_state_history`

`status_requests` (TR02)

2 - 3 Minuten

4 - 5 Minuten

16.06.20209.30.4.0
1075`accounting_blocks`10 - 15 Minuten05.06.20209.30.1.0
1074

`bills`
`tariff_positions` (viele Tarifpositionen)
`waypoints`

6 - 8 Minuten
3 - 5 Minuten
10 - 15 Minuten

28.05.20209.30.0.83
1073-1 - 2 Minuten15.05.20209.29.26.0
1072-1 - 2 Minuten12.05.20209.29.24.0
1071-1 - 2 Minuten08.05.20208.29.14.12
1070`tariff_positions` (viele Tarifpositionen)3 - 5 Minuten06.05.20208.29.14.11
1069

`tariff_positions` (viele Tarifpositionen)
`addresses`
`waypoints`

3 - 5 Minuten
2 - 3 Minuten
10 - 15 Minuten

29.04.20208.29.14.9
1068-1 - 2 Minuten21.04.20208.29.14.7
1067-1 - 2 Minuten17.04.20208.29.14.6
1066-1 - 2 Minuten12.04.20208.29.14.5
1065-1 - 2 Minuten07.04.20208.29.14.4
1064-1 - 2 Minuten02.04.20208.29.14.3
1063-1 - 2 Minuten31.03.20208.29.14.1
1062

`orders`
`addresses`

6 - 8 Minuten
2 - 3 Minuten

25.03.20208.29.14.0
1061`base_order_cargo_contents`4 - 5 Minuten24.03.20208.29.14.0
1060-1 - 2 Minuten19.03.20208.29.13.0
1059

`waypoint_time_restriction`
`trips` (2 Durchläufe)
`addresses`

2 - 3 Minuten
20 - 30 Minuten
2 - 3 Minuten

11.03.20208.29.12.0
1058-1 - 2 Minuten04.03.20208.29.11.0
1057-1 - 2 Minuten27.02.20208.29.11.0
1056-1 - 2 Minuten20.02.20208.29.11.0
1055

`orders` (Erweiterung Enum ohne Temp-Tabelle)
`trips` (Erweiterung Enum ohne Temp-Tabelle)

3 - 5 Minuten
3 - 5 Minuten

29.01.20208.28.17.0
1054

`accounting_blocks`
`tariff_positions` (viele Tarifpositionen)

10 Minuten
3 - 5 Minuten

16.01.20208.28.16.0
1053

`route_calculations`
`route_calculations_segments`
`billing_positions`
`trips`
`transport_bookings`

4 - 5 Minuten
4 - 5 Minuten
4 - 5 Minuten
10 - 15 Minuten
4 - 5 Minuten

13.01.20208.28.15.0
1052

`tariff_positions` (viele Tarifpositionen)
`orders`

3 - 5 Minuten
6 - 8 Minuten

10.12.20198.28.14.0
1051

`addresses`
`tariff_positions` (viele Tarifpositionen)

2 - 3 Minuten
3 - 5 Minuten

27.11.20198.28.12.0
1050`addresses`2 - 3 Minuten22.11.20198.28.11.0
1049-1 - 2 Minuten20.11.20198.28.10.0
1048

`orders`
`tariff_positions` (viele Tarifpositionen)
`waypoints`

6 - 8 Minuten
3 - 5 Minuten
10 - 15 Minuten

14.11.20198.28.10.0
1047

`waypoints`
`bills`

10 - 15 Minuten
5 - 8 Minuten

07.11.20198.28.10.0
1046-1 - 2 Minuten31.10.20198.28.7.0
1045-1 - 2 Minuten17.10.20198.28.6.0
1044

`addresses`
`trips`

2 - 3 Minuten
10 - 15 Minuten

10.10.20198.28.5.0
1043`orders`6 - 8 Minuten26.09.20198.28.3.0
1042-1 - 2 Minuten19.09.20198.28.2.0
1041

`trips` (2 Durchläufe)

4 - 5 Minuten12.09.20198.28.0.5
1040-1 - 2 Minuten30.08.20198.28.0.4
1039`addresses`2 - 3 Minuten23.08.20198.27.5
1038-1 - 2 Minuten15.08.20198.27.5
1037-1 - 2 Minuten08.08.20198.27.5
1036-1 - 2 Minuten25.07.20198.27.3
1035

`opening_times`

`orders`

`tariff_positions` (viele Tarifpositionen)

2 - 3 Minuten

5 Minuten

3 - 5 Minuten

18.07.20198.27.2
1034-0,5 Minuten05.07.20198.27.0
1033`waypoints`10 - 15 Minuten28.06.20198.27.0
1032`waypoints`10 - 15 Minuten19.06.20198.27.0
1031`tariff_positions` (viele Tarifpositionen)3 - 5 Minuten19.06.20198.26.7
1030

`trips`

`transport_booking_state`

`transport_booking_state_log`

`transport_bookings`

10 - 15 Minuten

10 - 15 Minuten

10 - 15 Minuten

4 - 5 Minuten

12.06.20198.26.6
1029`waypoints`10 - 15 Minuten05.06.20198.26.5
1028`waypoints`10 - 15 Minuten07.05.20198.26.0
1027`accounting_positions`4 - 6 Minuten18.04.20198.26.0
1026`transport_bookings`0,5 Minuten12.04.20198.26.0
1025

`address_mandator_information`

0,5 Minuten14.03.20198.26.0
1024

`custom_transport_booking_command`

`transport_booking_state`

`transport_booking_state_log`

`transport_bookings`

1 - 2 Minuten

1 - 2 Minuten

5 - 10 Minuten

1 - 2 Minuten

28.02.20198.26.0
1023

`waypoints`

10 - 15 Minuten

31.01.20198.24.19
1022

`waypoint_cargo_contents`

`status_requests` (TR02)

4 - 5 Minuten

2 - 3 Minuten

25.01.20198.24.19
1021

`orders`

`transport_bookings` (TR02 | 2 Durchläufe)

`status_requests` (TR02 | 2 Durchläufe)

5 Minuten

6 - 8 Minuten

4 - 5 Minuten

14.12.20188.24.18
1020

`billing_positions`

`trip_waypoints`

`waypoint_cargo_contents`

4 - 5 Minuten

5 Minuten

4 - 5 Minuten

07.12.20188.24.17
1019-0,5 Minuten06.12.20188.24.16
1018-0,5 Minuten23.11.20188.24.15
1017

`waiting_time_positions` (viele Wartezeit-Positionen)

1 - 2 Minuten

21.11.20188.24.14
1016

`tariff_positions` (viele Tarifpositionen)

3 - 5 Minuten

16.11.20188.24.14
1015

-

0,5 Minuten

09.11.20188.24.13
1014

`bills`

`accounting_blocks`

`orders`

`route_calculations_segment_tolls`

`trips`

5 - 8 Minuten

10 Minuten

5 Minuten

3 - 4 Minuten

5 - 10 Minuten



1013

`accounting_blocks`

3 x Updates auf `accounting_blocks`

10 Minuten

10 Minuten



1012

`transport_bookings` (TR02)

`trip_waypoints`

3 - 4 Minuten

5 Minuten



1011

`tariff_position`

`waypoints`

2 - 4 Minuten

10 - 15 Minuten



1010

`waypoint_cargo_contents`

4 - 5 Minuten



1009

-

0,5 Minuten



1008

-

0,5 Minuten



1007

`billing_positions`

4 - 5 Minuten



1006

-

0,5 Minuten



1005

`pallet_exchange`

4 - 5 Minuten



1004

`waypoints`

`waypoint_cargo_contents`

`orders`

`bills`

`trips`

`waypoints`

`orders`

`trip_waypoints`

`trips`

10 - 15 Minuten

4 - 5 Minuten

5 Minuten

5 - 8 Minuten

5 - 10 Minuten

10 - 15 Minuten

5 Minuten

5 Minuten

5 - 10 Minuten



1003

`status_history`

4 - 5 Minuten



1002

`waypoint_cargo_contents` (2 Durchläufe)

`bills` (2 Durchläufe)

`billing_positions`

`accounting_blocks`

8 - 10 Minuten

10 - 15 Minuten

4 - 5 Minuten

10 Minuten



1001

`accounting_blocks` (2 Durchläufe)

`orders`

`trips`

`waypoints`

`trip_waypoints`

10 - 15 Minuten

5 Minuten

5 - 10 Minuten

10 - 15 Minuten

5 Minuten



993

`status_requests` (TR02)

`no_shows`

`transport_booking_state`

`accounting_blocks` (2 Durchläufe)

`bills` (2 Durchläufe)

`incoming_payments` (2 Durchl. + 2 Update-Durchl.)

2 - 3 Minuten

1 Minute

2 - 3 Minuten

10 - 15 Minuten

10 - 15 Minuten

2 - 3 Minuten








955

`status_request_to_transport_booking` (TR02)

`waypoint_activity_resource`

`waypoint_activity_conflict` (2 Durchläufe)

2 Minuten

1 Minute

1 - 2 Minuten



954-0,5 Minuten

953`trips`5 - 10 Minuten

952`tariff_position`2 - 4 Minuten

951`addresses`1 Minute

950`grid_postcode_range`1 Minute

949`trips` (2 Durchläufe: Neue Spalten + Neue Indizes)10 - 15 Minuten

948-0,5 Minuten

947

`waypoints`
`waypoint_activity`
`waypoint_time_restriction`

10 - 15 Minuten
2 - 4 Minuten
2 - 4 Minuten



946-0,5 Minuten


Ältere Patches

Patches bis 945