Thumbnail db

Ask for help and post your question on how to use XnView Classic.

Moderators: XnTriq, xnview

Post Reply
obelisk
Posts: 402
Joined: Fri Jan 09, 2009 9:54 am

Thumbnail db

Post by obelisk » Sun Aug 02, 2009 11:06 pm

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:

punter
Posts: 1
Joined: Mon Jun 15, 2009 3:24 am

Re: Thumbnail db

Post by punter » Mon Aug 03, 2009 7:24 am

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.

User avatar
xnview
Author of XnView
Posts: 32055
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Thumbnail db

Post by xnview » Mon Aug 03, 2009 9:53 am

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?
Pierre.

obelisk
Posts: 402
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post by obelisk » Mon Aug 03, 2009 11:16 pm

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.

User avatar
Clo
XnThusiast
Posts: 4441
Joined: Sun Oct 17, 2004 4:57 am
Location: Bordeaux, France
Contact:

Re: Thumbnail db

Post by Clo » Mon Aug 03, 2009 11:48 pm

: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
Old user ON SELECTIVE STRIKE till further notice

User avatar
xnview
Author of XnView
Posts: 32055
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Thumbnail db

Post by xnview » Wed Aug 05, 2009 7:09 am

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?
Pierre.

obelisk
Posts: 402
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post by obelisk » Fri Aug 07, 2009 6:43 am

No not yet, what does optimise do? I thought it just removes deletes files, which I don't have any of.

pic_viewer
Posts: 251
Joined: Sat Nov 17, 2007 7:53 am
Location: Germany

Re: Thumbnail db

Post by pic_viewer » Sun Aug 09, 2009 11:10 am

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

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Re: Thumbnail db

Post by JohnFredC » Sun Aug 09, 2009 1:14 pm

2pic_viewer

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

obelisk
Posts: 402
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post by obelisk » Sun Aug 09, 2009 10:56 pm

defrag does nothing to the speed. I do it every 2wks anyway due to this stuff.

User avatar
JohnFredC
XnThusiast
Posts: 2010
Joined: Wed Mar 17, 2004 8:33 pm
Location: Sarasota Florida

Re: Thumbnail db

Post by JohnFredC » Sun Aug 09, 2009 11:36 pm

Every tiny little bit adds up, over time, even if you can't detect improvement of a single instance
John

User avatar
xnview
Author of XnView
Posts: 32055
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Thumbnail db

Post by xnview » Mon Aug 10, 2009 7:57 am

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?
Pierre.

User avatar
ckv
Posts: 779
Joined: Wed Feb 02, 2005 2:30 pm
Location: Glow
Contact:

Re: Thumbnail db

Post by ckv » Mon Aug 10, 2009 10:00 am

[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.
XnView Tweak UI - Tool to customize your XnView beyond the regular XnView options.
UI-less Settings - Documentation of all the hidden settings in XnView.
XFAM - Tool to create and customize XnView file associations.

pic_viewer
Posts: 251
Joined: Sat Nov 17, 2007 7:53 am
Location: Germany

Re: Thumbnail db

Post by pic_viewer » Tue Aug 11, 2009 4:46 am

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.

obelisk
Posts: 402
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post by obelisk » Tue Aug 11, 2009 10:54 pm

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.

Post Reply