Validating database hash is painfully slow

[KevinInSeattle]

I'm using Launchbox v13.27 and I have a rather large game library (~9000 games). When adding games, the 'validating database hash' portion is taking several minutes to complete. Is this a known issue or is there anything I can do to speed this up (besides deleting games)? Thank you.

 

[Dartz]

is happening to me too , hope is not because of a large collection of games imported and that can be fixed soon on a new release

[Jabb3rJaw]

I just noticed this as well. I added one game and it took almost 5 minutes mostly stuck on the database hash. 

[EkajArmstro]

yeah same issue -- I feel like it has to be a "recent-ish" regression because I was not having this issue before

[Sprinklezonk]

Any mods looking into this? Happening to me as well. Both when adding games and manually updating the Games Database Metadata.

 

[erebus316]

Has there been any kind of update on this? Or perhaps a way to turn off refreshing metadata every single day? 

This is getting quite annoying and making it hard to complete my collection. I've slowly started looking into other front ends because of this

[JoeViking245]

3 hours ago, erebus316 said:

Has there been any kind of update on this?

In the 13.28 beta release...
"Improvement: LocalDb startup work has been optimized to reduce startup overhead during local metadata database initialization and lookups"

 

This seems to include the updating of the local database which only occurs once per day (or roughly every 24 hours).  My tests for updating the local database:
v13.27               1 minute 43 seconds
v13.28 (beta)    37 seconds.

 

[Rlad]

If its happening everyday that's because you have automated imports turned on is it not? Turn that off and back on when you have games to add, or until 13.28 is released. 

 

 

[erebus316]

Thanks for the update Joe, any idea when the rest of us will be able to update to 13.28? 

 

@Rlad automated imports are not turned on.. Just after 24 hours it always wants to update the database and it takes over 10 minutes every single time and usually it fails and I just crash launchbox.  The only alternative is adding games 1 by 1 and saying no every time it asks you to update.

[JoeViking245]

24 minutes ago, erebus316 said:

Thanks for the update Joe, any idea when the rest of us will be able to update to 13.28? 

You're welcome. 
As far as when the official 13.28 release will be, I'm not in "that" loop.  aka, don't know.

 

24 minutes ago, erebus316 said:

automated imports are not turned on.. Just after 24 hours it always wants to update the database

Automated imports can be triggered via the settings:
Tools < Options < General < Automated Imports -- Enable Automatic ROM Imports
Tools < Manage < Storefronts -- Enable Automatic Imports On Startup

The local database file should only get updated if either of those finds and imports new games (assuming they're enabled), if you manually import new games or if you run:
Tools < Download < Update Metadata and Media for ... Games...  (which gives you the option to not update it)
Tools < Download < Force Update Games Database Metadata...

 

There may be 1 or 2 other actions that I missed.  But the local database file won't be updated unless one of these actions are triggered.