Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Only apply sqlite vacuum command when elements are deleted from the database.#1414

Merged
ahojnnes merged 1 commit into
colmap:devcolmap/colmap:devfrom
ferreram:database_vacuum_only_on_clearingferreram/colmap:database_vacuum_only_on_clearingCopy head branch name to clipboard
Jan 31, 2022
Merged

Only apply sqlite vacuum command when elements are deleted from the database.#1414
ahojnnes merged 1 commit into
colmap:devcolmap/colmap:devfrom
ferreram:database_vacuum_only_on_clearingferreram/colmap:database_vacuum_only_on_clearingCopy head branch name to clipboard

Conversation

@ferreram

Copy link
Copy Markdown
Contributor

Fix for #1413 . Vacuum command was applied whenever the close function is called leading to important delay whenever accessing the database. As the vacuum command is meant to decrease the size of db files by deleting allocated chunks of memory not used anymore, the PR only applies it when elements are deleted from the database.

@ahojnnes

Copy link
Copy Markdown
Contributor

Setting mutable on fields is feels dangerous, as we are giving the false impression of not mutating the state of the object, which might be problematic when concurrently accessing it. I guess, we could ignore this problem in this specific case, as concurrent database access is anyway prohibited. Thanks for the fix.

@ahojnnes
ahojnnes merged commit 2b72306 into colmap:dev Jan 31, 2022
@wwh301

wwh301 commented Feb 8, 2022

Copy link
Copy Markdown

Hi!
This fix a great problem!
But we guess why it needs 5~6 seconds to response, when opening "Database management"->"Overlapping images".
Do you met the same situation?
Thank you so much!

lucasthahn pushed a commit to tne-ai/colmap that referenced this pull request Aug 17, 2022
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.

4 participants

Morty Proxy This is a proxified and sanitized view of the page, visit original site.