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


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

Re: Close all open DBFs and reopen

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>

Show all headers | View raw


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


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