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

Extract DB files to a subdirectory within temporary folder #1155

Open
belugabehr opened this issue Aug 7, 2024 · 2 comments
Open

Extract DB files to a subdirectory within temporary folder #1155

belugabehr opened this issue Aug 7, 2024 · 2 comments

Comments

@belugabehr
Copy link

Is your feature request related to a problem? Please describe.

The library performs a cleanup routine of the /tmp directory at the start of every execution.

https://github.com/xerial/sqlite-jdbc/blob/61fda53dd39bc31dbf46f5f4523d85334f6c0fb9/src/main/java/org/sqlite/SQLiteJDBCLoader.java#L90C48-L90C58

This means that the duration of time to perform this action depends on the number of files in the /tmp directory at the time of startup.

Describe the solution you'd like
This can be mostly mitigated by first creating a sub-directory in the /tmp directory (e.g., "xerial-sqlite-jdbc") and only store JDBC native libs in this directory. The size of this directory will be much less at risk of having large numbers of files present.

@gotson
Copy link
Collaborator

gotson commented Aug 12, 2024

PR welcome

@gotson
Copy link
Collaborator

gotson commented Aug 26, 2024

I thought about that, and we already have org.sqlite.tmpdir, so this seems redundant. What do you think?

@gotson gotson changed the title [Feature] Extract DB files to a subdirectory within temporary folder Extract DB files to a subdirectory within temporary folder Aug 26, 2024
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

2 participants