Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #3436
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Close all open DBFs and reopen |
| Date | 2012-05-06 15:38 -0700 |
| Organization | http://groups.google.com |
| Message-ID | <33288610.3165.1336343923517.JavaMail.geo-discussion-forums@ynff16> (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> <fapdq7pf4i0r7bi8d1c2sj2mtf495ag8on@4ax.com> |
Dear D. J. W. van Kooten: On Sunday, May 6, 2012 2:00:44 PM UTC-7, D. J. W. van Kooten wrote: > On Fri, 4 May 2012 09:24:16 -0700 (PDT), dlzc <dl***@cox.net> wrote: > > Hello David, > > > 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. > > That's also an option of ADS, when using their > native format. I do not like this option however. > Having the records in natural order equal to the > order of addition, and being able to access > deleted records for a while (until they are > really packed) can help a lot in solving problems. You can achieve the same effect, by issuing a serial number to each record as it is added, and reuse records with the smallest / oldest serial number first. > When using such a feature, you would need to > do a lot of extra work before having the same > 'check options'. And the advantage may be little; > some databases may even see more deletions than > additions when you introduce the feature and are > still left with deleted records which may need > packing at some point. Agreed. The OP however is describing a problem, wherein packing becomes necessary. So this probably will not affect his case. Additionally, is there a guarantee that when packed, the remaining undeleted records are in the order they were added? I can imagine rolling records down from the end of the file to fill in spaces for deleted records, as a means to speed the operation up. 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