Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add timing to insert scripts #174

Closed
gm3dmo opened this issue May 29, 2024 · 1 comment
Closed

Add timing to insert scripts #174

gm3dmo opened this issue May 29, 2024 · 1 comment

Comments

@gm3dmo
Copy link
Owner

gm3dmo commented May 29, 2024

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
Copy link
Owner Author

gm3dmo commented Jun 4, 2024

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

@gm3dmo gm3dmo closed this as completed Jun 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant