English

Go Back   Champions of Regnum > English > Technical Support

Technical Support Questions about game technical support to the users of the community

Reply
 
Thread Tools Display Modes
Old 12-29-2012, 08:44 AM   #1
_Enio_
Marquis
 
_Enio_'s Avatar
 
Join Date: Aug 2007
Location: Germany
Posts: 1,843
_Enio_ will become famous soon enough
Default "res_disk_retriever = sqlite" very slow game start

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

Quote:
Originally Posted by surak View Post
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.
__________________
Fix the Marksman subclass: Suggestion

Last edited by _Enio_; 12-29-2012 at 10:13 AM.
_Enio_ no ha iniciado sesión   Reply With Quote
Old 12-29-2012, 10:04 AM   #2
ieti
Count
 
ieti's Avatar
 
Join Date: Oct 2008
Location: Sofia, Bulgaria
Posts: 1,377
ieti is on a distinguished road
Default

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.
__________________
RA | Ignis | Lilla My | Conjurer | EVIL IGNIS ROCK
Horus | Syrtis | ieti | Conjurer | INQUISITION | LONG GONE
ieti no ha iniciado sesión   Reply With Quote
Old 12-29-2012, 10:07 AM   #3
Kitsuni
Baron
 
Join Date: Dec 2008
Posts: 886
Kitsuni is on a distinguished road
Default

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).
Kitsuni no ha iniciado sesión   Reply With Quote
Old 12-29-2012, 10:13 AM   #4
_Enio_
Marquis
 
_Enio_'s Avatar
 
Join Date: Aug 2007
Location: Germany
Posts: 1,843
_Enio_ will become famous soon enough
Default

Hm, I didnt have that option enabled (update all resources at once).
__________________
Fix the Marksman subclass: Suggestion
_Enio_ no ha iniciado sesión   Reply With Quote
Old 12-29-2012, 12:28 PM   #5
ieti
Count
 
ieti's Avatar
 
Join Date: Oct 2008
Location: Sofia, Bulgaria
Posts: 1,377
ieti is on a distinguished road
Default

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

Thumbs up @Kitsunie.
__________________
RA | Ignis | Lilla My | Conjurer | EVIL IGNIS ROCK
Horus | Syrtis | ieti | Conjurer | INQUISITION | LONG GONE
ieti no ha iniciado sesión   Reply With Quote
Old 12-29-2012, 03:26 PM   #6
NotScias
Baron
 
NotScias's Avatar
 
Join Date: Aug 2009
Location: /dev/null
Posts: 769
NotScias will become famous soon enough
Default

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.
__________________

The other realm awaits...
Now playing much better games
NotScias no ha iniciado sesión   Reply With Quote
Old 12-29-2012, 06:51 PM   #7
Kitsuni
Baron
 
Join Date: Dec 2008
Posts: 886
Kitsuni is on a distinguished road
Default

Quote:
Originally Posted by _Enio_ View Post
Hm, I didnt have that option enabled (update all resources at once).
Does it slow down on loading times if you enable this option?

Quote:
Originally Posted by Shining-Scias View Post
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.
Also, the sqlite code also seems to use a single, large (~4GB) database, while the SDB code used multiple separate files.

I don't understand how this can be more efficient. It seems to me like it might reduce fragmentation, but you're still going to incur massive seek times when going from one end of the database to the other, even with low fragmentation on the file. Not sure what NGD was thinking here...

Would be nice if they explained some of the reasons for doing things this way (but I won't hold my breath).
Kitsuni no ha iniciado sesión   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:57 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
NGD Studios 2002-2016 © All rights reserved