Got it.. I always make a quick copy of the DB before I do anything to the DB, and keep them for a couple of weeks, so I could use the DB copy to recover anything I might need with my new copy of R:Scope and unload the recovered data to move to the active DB.
Thanks for the info, I just wanted to make sure I was not creating any new issues by doing this more frequently. -- Frank Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Minyo II Sent: Wednesday, May 04, 2011 3:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Over reloading/repacking 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 _______________________________________________________________________ This Email has been scanned for all viruses by PAETEC Email Scanning Services, utilizing MessageLabs proprietary SkyScan infrastructure. If you need assistance, please contact the Systems Administrator, Frank Taylor at [email protected] - 617-790-3093. _______________________________________________________________________
