Frank, I am no expert but I try to unload/load every week. I have never run into ay problems and doubt you would either. My database is small and I use 7.6.
James Belisle -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: Wednesday, May 04, 2011 1:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Over reloading/repacking 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 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]
