"res_disk_retriever = sqlite" very slow game start

[_Enio_]

I recently changed res_disk_retriever var to "sqlite" to check if its faster than the sdb format (and as surak hinted that its more advanced than sdb, see quote) and noticed a very slow loading before arriving at my characters screen.

Process explorer reported very high read access by the game while loading, is there maybe some integrity check on the ressource.db activated during game startup?

The delay on loading is approximated 3 times longer than copying the whole file.

Disabled it for now again but im curious about this delay and if someone can confirm this and of course - if it can be turned off.


Regards

Edit: Running on Windows 7

Originally Posted by surak

Duh.

That's the problem with really OLD code -.-

My suggestion: change res_disk_retriever = sdb to res_disk_retriever = sqlite in game.cfg and be happy.

[ieti]

It is several times slower than the sdb to me too. Latest update made it little faster, but it is still slower.

Debian Squeeze here.

[Kitsuni]

Something may be broken between the sqlite code and the "Update all resources at once" option.

Disabling it gave me normal load times again, up to 1/10th of before (or less).

[_Enio_]

Hm, I didnt have that option enabled (update all resources at once).

[ieti]

Hmm removing that checkbox speeds things up dramatically for me. This is strange...

Thumbs up @Kitsunie.

[NotScias]

Similar issue here.

If I enable the sqlite retriever and download all ressources option, the game freezes a few seconds before character selection but does no disk I/O access at all, then resumes loading normally.

Anyways, even with the download all option disabled, there's no tremendous improvement over sdb. I just notice a slightly faster loading time between NGD logo and char select screen.

Linux 64-bit - On a RAID0 array.