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


Groups > comp.lang.clipper.visual-objects > #4536 > unrolled thread

Speed Orderkeycount

Started byD.J.W. van Kooten <public@ic2remove.this.com>
First post2012-12-31 15:29 +0100
Last post2013-02-02 09:27 +0100
Articles 20 on this page of 36 — 12 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

Page 1 of 2  [1] 2  Next page →


#4536 — Speed Orderkeycount

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2012-12-31 15:29 +0100
SubjectSpeed Orderkeycount
Message-ID<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

[toc] | [next] | [standalone]


#4537

Fromdlzc <dlzc1@cox.net>
Date2012-12-31 10:39 -0800
Message-ID<97f5db7a-51a7-46d4-98ac-c3245568372d@googlegroups.com>
In reply to#4536
Dear D. J. W. van Kooten:

On Monday, December 31, 2012 7:29:27 AM UTC-7, D. J. W. van Kooten wrote:
> March this year we found that COUNT() litteraly
>  counted all records.

COUNT is short for the xBase/Clipper
   COUNT FOR ... which spans the database in current order.

How about reccount()?

> 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!

As workaround, you might try the dbOrdInfo() class, if VO has that.

Sorry I cannot actually answer your question, as posed.

David A. Smith

[toc] | [prev] | [next] | [standalone]


#4538

FromKarl Faller <k.faller_withoutthat_@onlinehome.de>
Date2012-12-31 19:44 +0100
Message-ID<r7n3e8lun8jghjcprn7r4lpbbmp1ksb7ae@4ax.com>
In reply to#4537
David,
>As workaround, you might try the dbOrdInfo() class, if VO has that.
it has ;-)

Best wishes for 2013!
Karl

[toc] | [prev] | [next] | [standalone]


#4541

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-01-02 15:58 +0100
Message-ID<9rh8e8tigj4s9ul2fgnc1fmncl2ern8jhe@4ax.com>
In reply to#4537
On Mon, 31 Dec 2012 10:39:14 -0800 (PST), dlzc <dlzc1@cox.net> wrote:

Hello David,


>How about reccount()?

I think I used that....being the slow one.
>
>As workaround, you might try the dbOrdInfo() class, if VO has that.


Thanks for the suggestion. It's actually
Server:OrderInfo(DBOI_KEYCOUNT)	but it gives the same performance
problem as Orderkeycount. And I am sure the latter has worked for
months without problems.

I find that on a direct access to the disk, it is only slow
(counting...) on the first startup; later changes are immediate. On
PC's that access the databasw via the network it is slow all the time.

I can not explain this....

DIck

[toc] | [prev] | [next] | [standalone]


#4540

From"Gerhard Bunzel" <g.bunzel@domonet.de>
Date2013-01-02 13:52 +0100
Message-ID<kc1af9$72g$1@news.m-online.net>
In reply to#4536
Dick,

> I am not sure when it started, SP4, SP4a, Windows update...

Is there a SP4a available for VO2.8???

TIA

Gerhard



"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 

[toc] | [prev] | [next] | [standalone]


#4546

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-01-03 11:12 +0100
Message-ID<a2mae8h7bghlv6a33crp7ntvr88o1pcpcm@4ax.com>
In reply to#4540
On Wed, 2 Jan 2013 13:52:43 +0100, "Gerhard Bunzel"
<g.bunzel@domonet.de> wrote:

Hello Gerhard,
>
>> I am not sure when it started, SP4, SP4a, Windows update...
>
>Is there a SP4a available for VO2.8???
>
Yes. Brian announced that 17-9 in the VPS NG. You had to unzip 
some DLL's in the ..\bin (which is a fast way) . I actually had the
idea that the main changes were actually about very specific things,
e.g. somehing about a Codejock toolbar which I didn't even know it
existed.

So if you are in VPS you can download SP4a and if you are not, this
patch may not be so important I guess.

Dick

[toc] | [prev] | [next] | [standalone]


#4550

From"Gerhard Bunzel" <g.bunzel@domonet.de>
Date2013-01-03 15:30 +0100
Message-ID<kc44ja$fjg$1@news.m-online.net>
In reply to#4546
Hello Dick,

thanks for that info.

It is very sad, that Brian has such a bad attitude about the work of VPS.
If there was more info, so that I can see 'VPS is doing something - a new SP 
or other things' - I will be motivated to also use VPS.
But outside VPS you hear nothing about such things e.g. a new SP.
A short info with 'We have a new SP in VPS with these changes......' and I 
can decide 'I will use that and go to VPS'.

Thanks

Gerhard


"D.J.W. van Kooten" <public@ic2remove.this.com> schrieb im Newsbeitrag 
news:a2mae8h7bghlv6a33crp7ntvr88o1pcpcm@4ax.com...
> On Wed, 2 Jan 2013 13:52:43 +0100, "Gerhard Bunzel"
> <g.bunzel@domonet.de> wrote:
>
> Hello Gerhard,
>>
>>> I am not sure when it started, SP4, SP4a, Windows update...
>>
>>Is there a SP4a available for VO2.8???
>>
> Yes. Brian announced that 17-9 in the VPS NG. You had to unzip
> some DLL's in the ..\bin (which is a fast way) . I actually had the
> idea that the main changes were actually about very specific things,
> e.g. somehing about a Codejock toolbar which I didn't even know it
> existed.
>
> So if you are in VPS you can download SP4a and if you are not, this
> patch may not be so important I guess.
>
> Dick 

[toc] | [prev] | [next] | [standalone]


#4551

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2013-01-03 15:13 +0000
Message-ID<kc47a7$gfa$1@speranza.aioe.org>
In reply to#4550
On 03-01-2013 14:30, Gerhard Bunzel wrote:
>
> thanks for that info.
>
> It is very sad, that Brian has such a bad attitude about the work of VPS.
> If there was more info, so that I can see 'VPS is doing something - a new SP
> or other things' - I will be motivated to also use VPS.
> But outside VPS you hear nothing about such things e.g. a new SP.
> A short info with 'We have a new SP in VPS with these changes......' and I
> can decide 'I will use that and go to VPS'.
>

I received my SP4 a few days ago and I have WhatsNew28SP4a.rtf and 
WhatsNew28SP4b.rtf in my installation.

SP4a adds two missing DLLs (CAVOUDF.DLL and CAVORDDB.DLL), corrects 
version number in cavo28run.dll, cavopp.dll and cavo28orun.dll, and 
corrects an issue in databrowser Unlink method "which lead to problems 
with the garbage collector". It also adds a new feature in DataWindow 
and ChildAppWindow related to the resize event when a toolbar not from 
the VO GUI Classes is used (like CodeJock's one). This last change is 
made only in VO28gui.dll.

SP4b only fixes something in SQLSelect related to "long data type 
columns", and Val() function not respecting ',' as decimal separator.

It's not fair that who first pay for SP4 don't have access to the 
corrections. Strange support/marketing politic :/

-- 
Carlos Rocha

[toc] | [prev] | [next] | [standalone]


#4554

From"Jamal" <vodotnet_nospam@yahoo.com>
Date2013-01-04 23:58 -0500
Message-ID<kc8bt8$2k4$1@dont-email.me>
In reply to#4551
Carols,

I guess we are back to square one of complaining about lack of support for 
bugs introduced in SP4.
I reported the DLL version issues when SP4 came out, but I guess the fixes 
were hidden in the VPS club (until now!)
There are also issues in Report Pro 3.9.

Jamal

"Carlos Rocha"  wrote in message news:kc47a7$gfa$1@speranza.aioe.org...

On 03-01-2013 14:30, Gerhard Bunzel wrote:
>
> thanks for that info.
>
> It is very sad, that Brian has such a bad attitude about the work of VPS.
> If there was more info, so that I can see 'VPS is doing something - a new 
> SP
> or other things' - I will be motivated to also use VPS.
> But outside VPS you hear nothing about such things e.g. a new SP.
> A short info with 'We have a new SP in VPS with these changes......' and I
> can decide 'I will use that and go to VPS'.
>

I received my SP4 a few days ago and I have WhatsNew28SP4a.rtf and
WhatsNew28SP4b.rtf in my installation.

SP4a adds two missing DLLs (CAVOUDF.DLL and CAVORDDB.DLL), corrects
version number in cavo28run.dll, cavopp.dll and cavo28orun.dll, and
corrects an issue in databrowser Unlink method "which lead to problems
with the garbage collector". It also adds a new feature in DataWindow
and ChildAppWindow related to the resize event when a toolbar not from
the VO GUI Classes is used (like CodeJock's one). This last change is
made only in VO28gui.dll.

SP4b only fixes something in SQLSelect related to "long data type
columns", and Val() function not respecting ',' as decimal separator.

It's not fair that who first pay for SP4 don't have access to the
corrections. Strange support/marketing politic :/

-- 
Carlos Rocha 

[toc] | [prev] | [next] | [standalone]


#4555

From"Willie Moore" <williem@wmconsulting.com>
Date2013-01-05 15:11 -0600
Message-ID<kca4u3$gua$1@speranza.aioe.org>
In reply to#4554
Jamal,

What issues are you seeing with rp39?

Regards,
Willie
Vulcan VIP

"Jamal"  wrote in message news:kc8bt8$2k4$1@dont-email.me...

Carols,

I guess we are back to square one of complaining about lack of support for
bugs introduced in SP4.
I reported the DLL version issues when SP4 came out, but I guess the fixes
were hidden in the VPS club (until now!)
There are also issues in Report Pro 3.9.

Jamal

"Carlos Rocha"  wrote in message news:kc47a7$gfa$1@speranza.aioe.org...

On 03-01-2013 14:30, Gerhard Bunzel wrote:
>
> thanks for that info.
>
> It is very sad, that Brian has such a bad attitude about the work of VPS.
> If there was more info, so that I can see 'VPS is doing something - a new 
> SP
> or other things' - I will be motivated to also use VPS.
> But outside VPS you hear nothing about such things e.g. a new SP.
> A short info with 'We have a new SP in VPS with these changes......' and I
> can decide 'I will use that and go to VPS'.
>

I received my SP4 a few days ago and I have WhatsNew28SP4a.rtf and
WhatsNew28SP4b.rtf in my installation.

SP4a adds two missing DLLs (CAVOUDF.DLL and CAVORDDB.DLL), corrects
version number in cavo28run.dll, cavopp.dll and cavo28orun.dll, and
corrects an issue in databrowser Unlink method "which lead to problems
with the garbage collector". It also adds a new feature in DataWindow
and ChildAppWindow related to the resize event when a toolbar not from
the VO GUI Classes is used (like CodeJock's one). This last change is
made only in VO28gui.dll.

SP4b only fixes something in SQLSelect related to "long data type
columns", and Val() function not respecting ',' as decimal separator.

It's not fair that who first pay for SP4 don't have access to the
corrections. Strange support/marketing politic :/

-- 
Carlos Rocha 

[toc] | [prev] | [next] | [standalone]


#4564

From"Jamal" <vodotnet_nospam@yahoo.com>
Date2013-01-08 13:26 -0500
Message-ID<kchocf$e7m$1@dont-email.me>
In reply to#4555
Willie,

I posted in the grafx cavo newsgroup with screen shots.

Jamal

"Willie Moore"  wrote in message news:kca4u3$gua$1@speranza.aioe.org...

Jamal,

What issues are you seeing with rp39?

Regards,
Willie
Vulcan VIP

"Jamal"  wrote in message news:kc8bt8$2k4$1@dont-email.me...

Carols,

I guess we are back to square one of complaining about lack of support for
bugs introduced in SP4.
I reported the DLL version issues when SP4 came out, but I guess the fixes
were hidden in the VPS club (until now!)
There are also issues in Report Pro 3.9.

Jamal

"Carlos Rocha"  wrote in message news:kc47a7$gfa$1@speranza.aioe.org...

On 03-01-2013 14:30, Gerhard Bunzel wrote:
>
> thanks for that info.
>
> It is very sad, that Brian has such a bad attitude about the work of VPS.
> If there was more info, so that I can see 'VPS is doing something - a new 
> SP
> or other things' - I will be motivated to also use VPS.
> But outside VPS you hear nothing about such things e.g. a new SP.
> A short info with 'We have a new SP in VPS with these changes......' and I
> can decide 'I will use that and go to VPS'.
>

I received my SP4 a few days ago and I have WhatsNew28SP4a.rtf and
WhatsNew28SP4b.rtf in my installation.

SP4a adds two missing DLLs (CAVOUDF.DLL and CAVORDDB.DLL), corrects
version number in cavo28run.dll, cavopp.dll and cavo28orun.dll, and
corrects an issue in databrowser Unlink method "which lead to problems
with the garbage collector". It also adds a new feature in DataWindow
and ChildAppWindow related to the resize event when a toolbar not from
the VO GUI Classes is used (like CodeJock's one). This last change is
made only in VO28gui.dll.

SP4b only fixes something in SQLSelect related to "long data type
columns", and Val() function not respecting ',' as decimal separator.

It's not fair that who first pay for SP4 don't have access to the
corrections. Strange support/marketing politic :/

-- 
Carlos Rocha 

[toc] | [prev] | [next] | [standalone]


#4552

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-01-03 16:52 +0100
Message-ID<tr9be8tamh884maoa1g1c7i2iehpk4srve@4ax.com>
In reply to#4550
On Thu, 3 Jan 2013 15:30:54 +0100, "Gerhard Bunzel"
<g.bunzel@domonet.de> wrote:

Hello Gerhard, Carlos,

>It is very sad, that Brian has such a bad attitude about the work of VPS.
>If there was more info, so that I can see 'VPS is doing something - a new SP 
>or other things' - I will be motivated to also use VPS.

I think it's a bit of a dillema. The original planning from Brian was
not to release a new VO outside VPS but nevertheless he did release
it. Logically, as long as Brian/Meinhard are motivated for that, and
VPS clients request it, new releases come out partly solving problems
in earlier releases and partly adding some functionality. As we're all
in the software business, we find it logical that such releases are
accessible by those who have some maintenance contract, which is VPS
for VO (and Vulcan).

I am not sure if releasing info about new SP's here make people decide
to buy a VPS or just start an endless discussion that these should be
free. Although, if it were my product,  I would personally release the
new features in public, my guess is that Brian feared the latter and
did not.

Dick

[toc] | [prev] | [next] | [standalone]


#4553

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2013-01-03 18:00 +0000
Message-ID<kc4h27$b2e$1@speranza.aioe.org>
In reply to#4552
Dick,

I understand that, and understand Brian. But things don't have to be 
black or white all the time, and with this they should be gray, imho.

I bought the same as Gerhard but I have a different thing, a better one 
I guess, just because he payed first. This is not right, and there's no 
contract, VPS, or whatever that could justify it. If I got SP4b, Gerhard 
and everybody else that bought SP4 before me should be entitled to get 
SP4b too. Enough said from me.

>
> I think it's a bit of a dillema. The original planning from Brian was
> not to release a new VO outside VPS but nevertheless he did release
> it. Logically, as long as Brian/Meinhard are motivated for that, and
> VPS clients request it, new releases come out partly solving problems
> in earlier releases and partly adding some functionality. As we're all
> in the software business, we find it logical that such releases are
> accessible by those who have some maintenance contract, which is VPS
> for VO (and Vulcan).
>
> I am not sure if releasing info about new SP's here make people decide
> to buy a VPS or just start an endless discussion that these should be
> free. Although, if it were my product,  I would personally release the
> new features in public, my guess is that Brian feared the latter and
> did not.
>

-- 
Carlos Rocha

[toc] | [prev] | [next] | [standalone]


#4556

FromKarl Faller <k.faller_withoutthat_@onlinehome.de>
Date2013-01-06 22:39 +0100
Message-ID<9pqje81t3i11bhcakgonmrpb9ke8ed5486@4ax.com>
In reply to#4553
Carlos,
> If I got SP4b, Gerhard 
>and everybody else that bought SP4 before me should be entitled to get 
>SP4b too. 
well, well.
Just for comparison: i just had to prolong my "support & updates"
contract on one of my cad softwares: 20% of the original "new" price
for ONE year more. ONLY, if i do so now, while the last period lasts.
If i let it slip, to get again "in", i'd pay a LOT more. 
Can't say, i'm happy with this, but OTOH, i understand that somehow
the bills have to be paid - and only "new" customers, buying a
unlimited licence, won't keep business running. Look where even MS is
steering to...
Last addendum: some months ago, the company, which, in a way, started
my business about 20 years ago, (as they developed and sold the hard-
and software, with which i make my money) declared insolvency - guess
what, they sold unlimited licences with free support...

Regards
Karl

[toc] | [prev] | [next] | [standalone]


#4557

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2013-01-07 01:30 +0000
Message-ID<kcd8hp$k83$1@speranza.aioe.org>
In reply to#4556
Karl,

> well, well.
> Just for comparison: i just had to prolong my "support & updates"
> contract on one of my cad softwares: 20% of the original "new" price
> for ONE year more. ONLY, if i do so now, while the last period lasts.
> If i let it slip, to get again "in", i'd pay a LOT more.
> Can't say, i'm happy with this, but OTOH, i understand that somehow
> the bills have to be paid - and only "new" customers, buying a
> unlimited licence, won't keep business running. Look where even MS is
> steering to...
> Last addendum: some months ago, the company, which, in a way, started
> my business about 20 years ago, (as they developed and sold the hard-
> and software, with which i make my money) declared insolvency - guess
> what, they sold unlimited licences with free support...
>

I would be glad with those 20%.
I paid $250 (50%) for a service pack of a product that costs $500 
(unlimited license) and I'm happy with that too. I even would pay the 
same in a couple of months for a SP5, as long as it would introduce new 
features. But I would not like to pay 1 single dollar for 2 missing DLLs 
that someone, by mistake, forgot to add to the service pack. This is 
ridiculous.
A company can't grow, or even survive, with unpleasant clients. I've 
seen to many people leaving the boat in the last few years, and this is 
worst than correcting minor faults for free (I'm not talking about new 
features).

-- 
Carlos Rocha

[toc] | [prev] | [next] | [standalone]


#4560

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-01-08 09:03 +0100
Message-ID<ajkne810q05r2qhsni571c3pgisdvsd3hm@4ax.com>
In reply to#4557
On Mon, 07 Jan 2013 01:30:11 +0000, Carlos Rocha
<carlos.rocha@doossier.com.removethis> wrote:

Hello Carlos,


>A company can't grow, or even survive, with unpleasant clients. 

<BG>

Sorry, couldn't resist. I think you mean 'unpleased clients', actually
the word is displeased. 

We have unpleasant clients too and I'm sure Brian  has them too.

Dick

[toc] | [prev] | [next] | [standalone]


#4562

From"Er!k \\/!$$Er" <nospam@nospam.url>
Date2013-01-08 12:57 +0100
Message-ID<al2fttFa2hfU1@mid.individual.net>
In reply to#4560
Hi Dick,

> We have unpleasant clients too and I'm sure Brian  has them too.
What makes you so sure? <g>

Erik

"D.J.W. van Kooten"  schreef in bericht 
news:ajkne810q05r2qhsni571c3pgisdvsd3hm@4ax.com...

On Mon, 07 Jan 2013 01:30:11 +0000, Carlos Rocha
<carlos.rocha@doossier.com.removethis> wrote:

Hello Carlos,


>A company can't grow, or even survive, with unpleasant clients.

<BG>

Sorry, couldn't resist. I think you mean 'unpleased clients', actually
the word is displeased.

We have unpleasant clients too and I'm sure Brian  has them too.

Dick 

[toc] | [prev] | [next] | [standalone]


#4563

FromCarlos Rocha <carlos.rocha@doossier.com.removethis>
Date2013-01-08 16:26 +0000
Message-ID<kchhbe$sd8$1@speranza.aioe.org>
In reply to#4560
OOps :P

On 08-01-2013 08:03, D.J.W. van Kooten wrote:
> On Mon, 07 Jan 2013 01:30:11 +0000, Carlos Rocha
> <carlos.rocha@doossier.com.removethis> wrote:
>
> Hello Carlos,
>
>
>> A company can't grow, or even survive, with unpleasant clients.
>
> <BG>
>
> Sorry, couldn't resist. I think you mean 'unpleased clients', actually
> the word is displeased.
>
> We have unpleasant clients too and I'm sure Brian  has them too.
>
> Dick
>

-- 
Carlos Rocha

[toc] | [prev] | [next] | [standalone]


#4543

FromDave Francis <suilvenassociates@googlemail.com>
Date2013-01-02 12:08 -0800
Message-ID<9b6a0462-891b-47f6-b2b1-dcf87f574533@googlegroups.com>
In reply to#4536
Dick,

IIRC the state of SetDeleted() is important for speed when using CDX functions.  It's one of the reasons we decided (years ago :o) to show all records, have ! Deleted() as a condition on all live tags and have a separate DELETED tag with Deleted() as the condition. 

It made sense once you thought how the CDX tag was built. It can simple look at the number of records in the CDX tag between 2 points without having to examine each one to see if it is deleted.

HTH

Dave Francis

On Monday, December 31, 2012 2:29:27 PM UTC, D. J. W. van Kooten wrote:
> 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

[toc] | [prev] | [next] | [standalone]


#4544

From"Urs Eggmann" <Urs.Eggmann@shinternet.ch>
Date2013-01-03 00:02 +0100
Message-ID<akjsk4F1nm0U1@mid.individual.net>
In reply to#4536
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

[toc] | [prev] | [next] | [standalone]


Page 1 of 2  [1] 2  Next page →

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web