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

feat(embedded/tools): initial SQL stress tool #760

Merged
merged 2 commits into from
May 17, 2021
Merged

Conversation

dmacvicar
Copy link
Contributor

This is an initial stress tool following the same pattern as stress_tool.go but using the embedded SQL engine.

Caveats:

  • It fails if the database exists
  • It generates serial IDs without persisting the last, therefore 2 consecutive runs would fail with duplicate IDs (perhaps a flag in the future indicating starting ID would help)

@coveralls
Copy link
Collaborator

Coverage Status

Coverage increased (+0.05%) to 87.646% when pulling 845682b on feat/sql_stress_tool into 3fb881f on master.

@SimoneLazzaris
Copy link
Collaborator

Looks good for a first implementation. Possible improvements:

  • add an option to use an existing database/table, so that the test can be run in series
  • give the option to read the values instead of just doing insert, so that we can also test read speed
  • git the option to have sequences, so that we can also check procedurally if insert are correctly read back

@dmacvicar dmacvicar merged commit aebf125 into master May 17, 2021
@dmacvicar dmacvicar deleted the feat/sql_stress_tool branch May 17, 2021 08:51
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

Successfully merging this pull request may close these issues.

3 participants