Thumbnail db

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

Moderators: XnTriq, xnview

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

Thumbnail db

Post 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:
punter
Posts: 1
Joined: Mon Jun 15, 2009 3:24 am

Re: Thumbnail db

Post 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.
User avatar
xnview
Author of XnView
Posts: 34089
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Thumbnail db

Post 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?
Pierre.
obelisk
Posts: 405
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post 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.
User avatar
Clo
XnThusiast
Posts: 4441
Joined: Sun Oct 17, 2004 4:57 am
Location: Bordeaux, France
Contact:

Re: Thumbnail db

Post 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
Old user ON SELECTIVE STRIKE till further notice
User avatar
xnview
Author of XnView
Posts: 34089
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Thumbnail db

Post 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?
Pierre.
obelisk
Posts: 405
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post by obelisk »

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 »

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 »

2pic_viewer

Wow! That Defraggler thing is very useful! Thanks for pointing it out!
John
obelisk
Posts: 405
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

Post by obelisk »

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 »

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: 34089
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Thumbnail db

Post 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?
Pierre.
User avatar
ckv
Posts: 786
Joined: Wed Feb 02, 2005 2:30 pm
Location: Glow
Contact:

Re: Thumbnail db

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

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: 405
Joined: Fri Jan 09, 2009 9:54 am

Re: Thumbnail db

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