Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #4536 > unrolled thread
| Started by | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| First post | 2012-12-31 15:29 +0100 |
| Last post | 2013-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
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 →
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2012-12-31 15:29 +0100 |
| Subject | Speed 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]
| From | dlzc <dlzc1@cox.net> |
|---|---|
| Date | 2012-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]
| From | Karl Faller <k.faller_withoutthat_@onlinehome.de> |
|---|---|
| Date | 2012-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-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]
| From | "Gerhard Bunzel" <g.bunzel@domonet.de> |
|---|---|
| Date | 2013-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-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]
| From | "Gerhard Bunzel" <g.bunzel@domonet.de> |
|---|---|
| Date | 2013-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]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2013-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]
| From | "Jamal" <vodotnet_nospam@yahoo.com> |
|---|---|
| Date | 2013-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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2013-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]
| From | "Jamal" <vodotnet_nospam@yahoo.com> |
|---|---|
| Date | 2013-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-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]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2013-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]
| From | Karl Faller <k.faller_withoutthat_@onlinehome.de> |
|---|---|
| Date | 2013-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]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2013-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-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]
| From | "Er!k \\/!$$Er" <nospam@nospam.url> |
|---|---|
| Date | 2013-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]
| From | Carlos Rocha <carlos.rocha@doossier.com.removethis> |
|---|---|
| Date | 2013-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]
| From | Dave Francis <suilvenassociates@googlemail.com> |
|---|---|
| Date | 2013-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]
| From | "Urs Eggmann" <Urs.Eggmann@shinternet.ch> |
|---|---|
| Date | 2013-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