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


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

Re: Speed Orderkeycount

From "Urs Eggmann" <Urs.Eggmann@shinternet.ch>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Speed Orderkeycount
Date 2013-01-03 00:02 +0100
Message-ID <akjsk4F1nm0U1@mid.individual.net> (permalink)
References <3983e852pa5rpb5avb2scr5og9t5ttu854@4ax.com>

Show all headers | View raw


Hi Dick,

I introduced my time measurement into the Init as follows. All methods were
very fast with 55'000 records.
How many records do you have in your dbf and how many are deleded?

regards
Urs

nBeginn := timeGetTime()
? SELF:oDCbBrowser1:Server:RECCOUNT
nEnde := timeGetTime()
? nEnde - nBeginn , ' milliSec'     // 0 mSec ! !
SELF:oDCbBrowser1:Server:GoTop()
?
nBeginn := timeGetTime()
? SELF:oDCbBrowser1:Server:Count()
nEnde := timeGetTime()
? nEnde - nBeginn , ' milliSec'     // 55 mSec
SELF:oDCbBrowser1:Server:GoTop()

nBeginn := timeGetTime()
? SELF:oDCbBrowser1:Server:OrderKeyCount()
nEnde := timeGetTime()
? nEnde - nBeginn , ' milliSec'    // 9 mSec
SELF:oDCbBrowser1:Server:GoTop()




"D.J.W. van Kooten" <public@ic2remove.this.com> schrieb im Newsbeitrag
news:3983e852pa5rpb5avb2scr5og9t5ttu854@4ax.com...
> March this year we found that COUNT() litteraly counted all records.
> We use it to show the number of e-mails in a bBrowser and obviously
> this caused unacceptable delay in displaying them. We also found this
> was not the case with OrderKeyCount.
>
> However, without a change in our code, we found that the delays are
> back, and this time in OrderKeyCount. This use to directly give an end
> result and now it can take up to some minutes!
>
> I am not sure when it started, SP4, SP4a, Windows update...
>
> Any ideas about it would be appreciated.
>
> Dick

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2012-12-31 15:29 +0100
  Re: Speed Orderkeycount dlzc <dlzc1@cox.net> - 2012-12-31 10:39 -0800
    Re: Speed Orderkeycount Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2012-12-31 19:44 +0100
    Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-02 15:58 +0100
  Re: Speed Orderkeycount "Gerhard Bunzel" <g.bunzel@domonet.de> - 2013-01-02 13:52 +0100
    Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-03 11:12 +0100
      Re: Speed Orderkeycount "Gerhard Bunzel" <g.bunzel@domonet.de> - 2013-01-03 15:30 +0100
        Re: Speed Orderkeycount Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2013-01-03 15:13 +0000
          Re: Speed Orderkeycount "Jamal" <vodotnet_nospam@yahoo.com> - 2013-01-04 23:58 -0500
            Re: Speed Orderkeycount "Willie Moore" <williem@wmconsulting.com> - 2013-01-05 15:11 -0600
              Re: Speed Orderkeycount "Jamal" <vodotnet_nospam@yahoo.com> - 2013-01-08 13:26 -0500
        Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-03 16:52 +0100
          Re: Speed Orderkeycount Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2013-01-03 18:00 +0000
            Re: Speed Orderkeycount Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2013-01-06 22:39 +0100
              Re: Speed Orderkeycount Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2013-01-07 01:30 +0000
                Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-08 09:03 +0100
                Re: Speed Orderkeycount "Er!k \\/!$$Er" <nospam@nospam.url> - 2013-01-08 12:57 +0100
                Re: Speed Orderkeycount Carlos Rocha <carlos.rocha@doossier.com.removethis> - 2013-01-08 16:26 +0000
  Re: Speed Orderkeycount Dave Francis <suilvenassociates@googlemail.com> - 2013-01-02 12:08 -0800
  Re: Speed Orderkeycount "Urs Eggmann" <Urs.Eggmann@shinternet.ch> - 2013-01-03 00:02 +0100
    Re: Speed Orderkeycount dlzc <dlzc1@cox.net> - 2013-01-02 20:29 -0800
      Re: Speed Orderkeycount "Urs Eggmann" <Urs.Eggmann@shinternet.ch> - 2013-01-03 13:53 +0100
        Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-03 14:47 +0100
    Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-03 12:04 +0100
  Re: Speed Orderkeycount "Paul D B" <polleke@NOMORESPAMhnt.be> - 2013-01-16 14:12 +0100
    Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-17 12:04 +0100
      Re: Speed Orderkeycount "Paul D B" <polleke@NOMORESPAMhnt.be> - 2013-01-22 13:16 +0100
        Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-01-22 16:02 +0100
          Re: Speed Orderkeycount "Paul D B" <polleke@NOMORESPAMhnt.be> - 2013-01-24 11:52 +0100
  Re: Speed Orderkeycount "Jamal" <vodotnet_nospam@yahoo.com> - 2013-01-25 15:19 -0500
    Re: Speed Orderkeycount D.J.W. van Kooten <public@ic2remove.this.com> - 2013-02-01 14:54 +0100
      Re: Speed Orderkeycount "Jamal" <vodotnet_nospam@yahoo.com> - 2013-02-01 09:31 -0500
  Re: Speed Orderkeycount "Jamal" <vodotnet_nospam@yahoo.com> - 2013-01-27 23:51 -0500
    Re: Speed Orderkeycount Camille Kater <katercam@pt.lu> - 2013-02-01 18:55 +0100
      Re: Speed Orderkeycount "Jamal" <vodotnet_nospam@yahoo.com> - 2013-02-01 18:06 -0500
        Re: Speed Orderkeycount Camille Kater <katercam@pt.lu> - 2013-02-02 09:27 +0100

csiph-web