Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #4544
| 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> |
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
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