Page 1 of 1
Fragmented db files?!
Posted: Tue Jan 13, 2009 4:43 am
by obelisk
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?
Posted: Wed Jan 14, 2009 2:36 am
by Jaff
+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)
Posted: Wed Jan 14, 2009 8:50 am
by obelisk
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
solution
Posted: Wed Jan 28, 2009 12:34 am
by Rebellious
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
Posted: Wed Jan 28, 2009 2:11 am
by obelisk
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
Posted: Wed Jan 28, 2009 10:26 pm
by Rebellious
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.