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

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 <kw@e﹐s-system.de>
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 <a0slclFaeoU1@mid.individual.net> (permalink)
References <b09or.180034$Od1.45938@fx32.am4> <on92q7lqd9u6h6jiai6duue2umiibiupmv@4ax.com> <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>
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 <pT8qr.447567$ed1.42521@fx04.am4>
Xref csiph.com comp.lang.clipper.visual-objects:3443

Show key headers only | 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