Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Karl Wochele Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Close all open DBFs and reopen Date: Tue, 08 May 2012 15:28:53 +0200 Lines: 40 Message-ID: References: <5078709.1251.1336148657030.JavaMail.geo-discussion-forums@ynmk20> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net 0g6PmNa7lWCevV98/3tF6QbwgrdTMr0ZSC4bnMtmdzirRSnqIz6lpE8hbBQCVU917Z Cancel-Lock: sha1:RxiMYERpWrsLpexfZfMdizBqkt0= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 In-Reply-To: Xref: csiph.com comp.lang.clipper.visual-objects:3443 Hi Martin, yes, blank indexes get slow. So don't use any... We use Str(recno(),10,0) as index-expression .and. deleted() as condition for our recycling-index.. Karl Am 08.05.2012 15:06, schrieb Martin: > I have been record recycling for over 20 years. > > But blank indexes get slow, and shrinking a file in size after an > archive is good > > On 04/05/2012 17:24, dlzc wrote: >> Dear Martin: >> >> On Thursday, May 3, 2012 2:01:14 AM UTC-7, Martin wrote: >>> Thanks all I will have a nose through >>> >>> It is so a database update can be done without >>> quitting the application, but file has to be >>> closed then reopened to use the new file format. >>> Planning to send a message from the updating >>> program to tell the other users to do a close >>> open. >>> >>> But more excited about the pack while in shared mode. >> >> You could be even more excited, if instead of blindly adding new >> records, you search for deleted records first, and re-used those that >> did not still have locks on them. Then packing becomes unnecessary. >> http://www.ghservices.com/gregh/clipper/trix0006.htm >> >> Obviously, this would be best handled in your own function for this >> purpose. >> >> David A. Smith >