gm3dmo / cmp

GNU General Public License v3.0
0 stars 1 forks source link

Add timing to insert scripts #174

Closed gm3dmo closed 3 months ago

gm3dmo commented 3 months ago
insert-all-companies
--------------------
Fetch table response code: 200
['name', 'notes']

insert-all-soldiers
-------------------
Fetch table response code: 200
<csv.DictReader object at 0x7fe0c18ca650>

The insert-all-soldiers script is taking quite some time on Azure. Reasons unknown.

Adding timings will help to quantify this.

gm3dmo commented 3 months ago

See #186

Sun Jun  2 17:23:43 UTC 2024
insert-all-cemeteries Fetch table response code: 200 time (seconds) to fetch: 0.21 time to insert 11.96
insert-all-pow-camps Fetch table response code: 200 time (seconds) to fetch: 0.19 time to insert 1.46
insert-all-ranks Fetch table response code: 200 time (seconds) to fetch: 0.22 time to insert 1.30
insert-all-decorations Fetch table response code: 200 time (seconds) to fetch: 0.23 time to insert 2.05
insert-all-companies Fetch table response code: 200 time (seconds) to fetch: 0.19 time to insert 9.04
insert-all-soldiers Fetch table response code: 200 time (seconds) to fetch: 1.07 time to insert 667.43
insert-all-soldier-imprisonments Fetch table response code: 200 time (seconds) to fetch: 0.21 time to insert 11.47
insert-all-soldier-deaths Fetch table response code: 200 time (seconds) to fetch: 0.22 time to insert 32.56
insert-all-soldier-decorations Fetch table response code: 200 time (seconds) to fetch: 0.26 time to insert 195.36