Fragmented db files?!

Ideas for improvements and requests for new features in XnView Classic

Moderators: XnTriq, xnview

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

Fragmented db files?!

Post by obelisk » Tue Jan 13, 2009 4:43 am

The db files are greatly fragmented. My cat db is 300kb but has 100 fragments
the cache db is 50mb and has 1500 fragments.

:? could you pre-allocate space for these to save such trouble?
:idea:

User avatar
Jaff
Posts: 67
Joined: Fri Dec 07, 2007 8:55 am
Location: Romania
Contact:

Post by Jaff » Wed Jan 14, 2009 2:36 am

+1
It would be nice to have a prealocated space for cache db (1/2/4MB segments selectable somewhere in options)
Meanwhile defragment your HDD with some defrag prog like Defraggler (freeware)
You can defragment a single file if you want (see picture)

Image
Last edited by Jaff on Wed May 13, 2009 1:43 pm, edited 1 time in total.
Imi este indiferent ce cred ceilalti despre mine, caci oricum fiecare crede ce-i convine lui si nu ceea ce e real, doar ca mi-ar fi placut sa ma vada asa cum sint de fapt, nu asa cum poate le-ar placea lor sa creada. Ei au ales deja...

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

Post by obelisk » Wed Jan 14, 2009 8:50 am

indeed. or just a simple "grow cache by " x MB option
I duno what cat db stores but I guess that can be hard coded to grow in 512kb

Rebellious
Posts: 39
Joined: Tue Jul 22, 2008 4:49 pm

solution

Post by Rebellious » Wed Jan 28, 2009 12:34 am

Use Sysinternals' "Contig" free utility, works on individual files, no need to defrag the whole partition.


http://technet.microsoft.com/en-us/sysi ... 97428.aspx

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

Post by obelisk » Wed Jan 28, 2009 2:11 am

yes, and doesn't help.
cuz my DB fragments every few days into 100+ bits
I'm still catagorizing my images.

until I finish in a few months, it's all crap

Rebellious
Posts: 39
Joined: Tue Jul 22, 2008 4:49 pm

Post by Rebellious » Wed Jan 28, 2009 10:26 pm

obelisk wrote:yes, and doesn't help.
cuz my DB fragments every few days into 100+ bits
I'm still catagorizing my images.

until I finish in a few months, it's all crap
You can run it automatically every day using Window's Task Scheduler. 100 fragments is OK, even if you pre-allocated space, your db data will likely not be contiguous.

Post Reply