Marco, The Temp Table corruption was from 7.6 When converting to 9.1 two months ago we did not change this back to using Temp Tables. I first wanted to get everything running smoothly after the conversion before I start adding or changing items such as this. But in the meantime I have seen the file utilization drop rapidly in the 9.1 Database along with a reciprocal increased time to pull data from these tables. A Repack and Reload always shows improved speed, but it seems like I need to do these more often now. I might try slowly changing some of my permanent table routines to use temp tables again and see how it goes.
-- 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 Marco Groeneveld Sent: Thursday, May 05, 2011 3:26 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Over reloading/repacking Hi, Just a question wh was it not working with the temp tables. Was this also with the latest release 9.1 ? Maybe if something is changed/updated in this solution you don't need the tables en so don't need to repair th database Marco ----- Original Message ----- From: "Gary Wendike" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, May 05, 2011 1:01 AM Subject: [RBASE-L] - Re: Over reloading/repacking Frank, I do an unload and reload every week day...Monday thru Friday. I have experience no problems. I do keep a copy of the database on a different harddrive just in case though. Database size runs about 3gig. Gary -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: Wednesday, May 04, 2011 2:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Over reloading/repacking 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. _______________________________________________________________________ _______________________________________________________________________ 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. _______________________________________________________________________
