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]
