Rather than RESIZE, if you want to reclaim OVER30 on a temporary file, howzabout CLEAR.FILE? Works a treat, ime.
Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan D Smith Sent: 24 March 2004 08:38 To: [EMAIL PROTECTED] Subject: Re: UniVerse vs Progress Performance Don't get me wrong Dynamic Files have there uses, but they are NOT maintenance free (as some people think) they are low maintenance. Files that do not increase in size or their increase can be predicted over a given period , in my view, should not be Dynamic (why use two file handles, where one will do). Also Dynamic Files are great for work files as they shrink and grow with use .... BUT the time hit is when the file has to grow again, for your temporary / work files have you considered using a minimum modulus to control the contraction of the file and hence making sure UniVerse does not need to repeat work it's already done. Finally, Dynamic Files never return there unused OVER30 space back to the machine, hence from time to time during maintenance you may wish to run RESIZE file * * * as this has the side effect on Dynamic Files of claiming back unused space. *********************************************************************************** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *********************************************************************************** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
