Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3436

Re: Close all open DBFs and reopen

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>

Show all headers | View raw


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


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