At 02:17 PM 05/04/2011, Frank Taylor wrote:
Is there such a thing as over reloading/packing your database ? Our
Database uses a lot of permanent tables to store temporary data. (
We used to use temp tables a long time ago, but ran into corruption
issues). This leads to a high number of fragmentation in our File 2
with utilization dropping quickly each day, which appears to slow
our DB down on lookups and printing. As standard practice I used to
do a Reload / Pack routine every Sunday with an unload/load every
month. But now we are getting busier and it seems like I need to do
a reload/repack on a daily basis to keep things running fast. So
the question is, is there such a thing as over doing a reload/repack
on a DB ? Anyone have experience with doing reloads frequently ?
Frank,
The only downside to frequent reloading/packing of a database
would be that Administrators would be unable to restore deleted
records using R:Scope.
R:Scope 9.1 (32/64):
http://www.rbase.com/products/rscope91/
Best regards,
John Minyo II
R:BASE Technologies, Inc.
Customer Service
