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

Create multiple prepared statments for concurrent access #38

Open
mwatts15 opened this issue Feb 10, 2015 · 0 comments
Open

Create multiple prepared statments for concurrent access #38

mwatts15 opened this issue Feb 10, 2015 · 0 comments

Comments

@mwatts15
Copy link
Owner

Draft
Errors similar to issue #31 have necessitated the introduction of locking around access to SQLite prepared statements in the FileCabinet component and this sort of locking will be added to TagDB statements as well. This has brought up the question of whether there may be a slow-down in operations due to lock-contention. This proposal attempts to address the question of whether this is a problem that needs attention and then to suggest a solution in the case that it does.

  1. Determine if there is significant contention over access to prepared statements. Resolving issue Get automated source coverage information for unit tests #25 would be helpful here.
  2. Use statement semaphores to allocate replicates of the prepared statement and make the semaphore tables 2D.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant