Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3443
| From | Karl Wochele <kw@e﹐s-system.de> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Close all open DBFs and reopen |
| Date | 2012-05-08 15:28 +0200 |
| Message-ID | <a0slclFaeoU1@mid.individual.net> (permalink) |
| References | (2 earlier) <r_cor.6575$%E2.1837@viwinnwfe01.internal.bigpond.com> <paa3q7ptbgtets7oqhjt4rlhiknge2eccg@4ax.com> <nPror.537498$xD4.284957@fx06.am4> <5078709.1251.1336148657030.JavaMail.geo-discussion-forums@ynmk20> <pT8qr.447567$ed1.42521@fx04.am4> |
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 >
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-02 12:37 +0100
Re: Close all open DBFs and reopen Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-05-02 14:27 +0200
Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-03 02:09 +1000
Re: Close all open DBFs and reopen Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-05-02 23:47 +0200
Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-03 10:01 +0100
Re: Close all open DBFs and reopen Mathias <mathias.hakansson@consultec.se> - 2012-05-04 00:20 -0700
Re: Close all open DBFs and reopen "richard.townsendrose" <richard.townsendrose@gmail.com> - 2012-05-04 05:21 -0700
Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-04 14:10 +0100
Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-04 14:10 +0100
Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-05 00:45 +1000
Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-08 14:04 +0100
Re: Close all open DBFs and reopen dlzc <dlzc1@cox.net> - 2012-05-04 09:24 -0700
Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-05 03:15 +1000
Re: Close all open DBFs and reopen D.J.W. van Kooten <public@ic2remove.this.com> - 2012-05-06 23:00 +0200
Re: Close all open DBFs and reopen dlzc <dlzc1@cox.net> - 2012-05-06 15:38 -0700
Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-07 11:57 +1000
Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-08 14:08 +0100
Re: Close all open DBFs and reopen Martin <spam@spam.spam> - 2012-05-08 14:06 +0100
Re: Close all open DBFs and reopen Karl Wochele <kw@e©os-system.de> - 2012-05-08 15:28 +0200
Re: Close all open DBFs and reopen D.J.W. van Kooten <public@ic2remove.this.com> - 2012-05-02 19:56 +0200
Re: Close all open DBFs and reopen "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2012-05-03 02:02 +1000
Re: Close all open DBFs and reopen Mathias <mathias.hakansson@consultec.se> - 2012-05-02 22:21 -0700
csiph-web