Fragmented db files?!

obelisk · 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?

Jaff · 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)

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

XnView Software

Fragmented db files?!

Fragmented db files?!

solution