Page 1 of 1

Thumbnail db

Posted: Sun Aug 02, 2009 11:06 pm
by obelisk
Today I looked at my Thumbnail db file since my xnview takes 15s to load now. It had 1356 fragments. Is anything being done to address this?
:idea:

Re: Thumbnail db

Posted: Mon Aug 03, 2009 7:24 am
by punter
obelisk wrote:Today I looked at my Thumbnail db file since my xnview takes 15s to load now. It had 1356 fragments. Is anything being done to address this?
:idea:
That is ordinary for pants filesystem.

Re: Thumbnail db

Posted: Mon Aug 03, 2009 9:53 am
by xnview
obelisk wrote:Today I looked at my Thumbnail db file since my xnview takes 15s to load now. It had 1356 fragments. Is anything being done to address this?
:idea:
15s, it's really strange? Try to rename the category.db?

Re: Thumbnail db

Posted: Mon Aug 03, 2009 11:16 pm
by obelisk
punter wrote: That is ordinary for pants filesystem.
Yes but yet all other programs get around this by preallocating or other means.

xnview wrote: 15s, it's really strange? Try to rename the category.db?
It takes about 10-15s to enter any pre-cached folder of 100+ pics, even if those pics have no category set. For folders with no cached pics it's immediate.

Re: Thumbnail db

Posted: Mon Aug 03, 2009 11:48 pm
by Clo
:arrow: Pierre

:) Hello !

“obelisk” wrote
Yes but yet all other programs get around this by preallocating or other means.
• For instance, in Total Commander we have the following INI entry :
ThumbnailPrealloc=100000
¤ Sets number of bytes to pre-allocate when creating the thumbnails database to avoid fragmentation.
:mrgreen: KR
Claude
Clo

Re: Thumbnail db

Posted: Wed Aug 05, 2009 7:09 am
by xnview
obelisk wrote:
xnview wrote: 15s, it's really strange? Try to rename the category.db?
It takes about 10-15s to enter any pre-cached folder of 100+ pics, even if those pics have no category set. For folders with no cached pics it's immediate.
15s?? Do you have tried optimise on DB?

Re: Thumbnail db

Posted: Fri Aug 07, 2009 6:43 am
by obelisk
No not yet, what does optimise do? I thought it just removes deletes files, which I don't have any of.

Re: Thumbnail db

Posted: Sun Aug 09, 2009 11:10 am
by pic_viewer
Download the freeware Defraggler from Piriform. It allows you to defragment only xnview.db file in blazing speed. Quicker than complaining here and waiting for an improvement...

Re: Thumbnail db

Posted: Sun Aug 09, 2009 1:14 pm
by JohnFredC
2pic_viewer

Wow! That Defraggler thing is very useful! Thanks for pointing it out!

Re: Thumbnail db

Posted: Sun Aug 09, 2009 10:56 pm
by obelisk
defrag does nothing to the speed. I do it every 2wks anyway due to this stuff.

Re: Thumbnail db

Posted: Sun Aug 09, 2009 11:36 pm
by JohnFredC
Every tiny little bit adds up, over time, even if you can't detect improvement of a single instance

Re: Thumbnail db

Posted: Mon Aug 10, 2009 7:57 am
by xnview
obelisk wrote:No not yet, what does optimise do? I thought it just removes deletes files, which I don't have any of.
Yes, and make a "VACUUM" command on the DB.
How many files do you have in the DB?

Re: Thumbnail db

Posted: Mon Aug 10, 2009 10:00 am
by ckv
[offtopic]
pic_viewer wrote:Download the freeware Defraggler from Piriform. It allows you to defragment only xnview.db file in blazing speed. Quicker than complaining here and waiting for an improvement...
JohnFredC wrote:Wow! That Defraggler thing is very useful! Thanks for pointing it out!
I must say, Piriform tools Recuva and CCleaner are great, but Defraggler once screwed up my system to unbootable state and i'm not the only one who got problems like this with Defraggler. So just a warning. :wink:

As an alternative here for Defraggler, I would recommend Sysinternals (Microsoft) Contig command line file defragmenter.

Re: Thumbnail db

Posted: Tue Aug 11, 2009 4:46 am
by pic_viewer
Of course there were versions of Defraggler that made problems. Same for every software, including XnView. Check the history listing. The current version is more than stable and includes lots of features that a command line version will never have.

Re: Thumbnail db

Posted: Tue Aug 11, 2009 10:54 pm
by obelisk
pic_viewer wrote:Of course there were versions of Defraggler that made problems.
Way to increase confidence. I've used 5 defrag programs since the days of Win95 and none of them ever created problems. When doing data critical software NO you should not have problems. They should be tested differently to eg xnview which won't delete your partition by mistake...


Tried the optimize on db, it still takes almost 10s to switch to a dir of raw files. Dir of jpg takes a little less. I have about 12k files in db.