Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #4710
| Subject | Re: Speed Orderkeycount |
|---|---|
| From | Camille Kater <katercam@pt.lu> |
| Date | 2013-02-02 09:27 +0100 |
| Message-ID | <510CCDD9.6020205@pt.lu> (permalink) |
| References | <3983e852pa5rpb5avb2scr5og9t5ttu854@4ax.com> <ke5047$n95$1@dont-email.me> <510C018E.4000901@pt.lu> <kehhpa$g6n$1@dont-email.me> |
| Newsgroups | comp.lang.clipper.visual-objects |
Thanks Jamal, Camille On 02/02/2013 00:06, Jamal wrote: > Camille, > > Setting it to FALSE disables the constant restoring of of DB work areas > after every call in DBServer class. Just look in the RDD SDK. Which in > turn speeds up your DB access. > > According to Mr. Data "If you want to use server objects in a filter you > need to enable the workarea restoring (using DbSetRestoreWorkArea(TRUE)) > for the complete lifetime of the filter". > > In my case I NEVER use filters. I have been using > DbSetRestoreWorkArea(FALSE) for several years with no problem. > > > Jamal > > "Camille Kater" wrote in message news:510C018E.4000901@pt.lu... > > Jamal, > > What is the purpose of DbSetRestoreWorkarea(TRUE/FALSE) ? > > Camille > > On 28/01/2013 05:51, Jamal wrote: >> Dick >> >> In your Start method, add DbSetRestoreWorkarea(FALSE) >> >> Also, on all network computers, configure NIC cards "Interrupt >> Moderation" option to Disabled (if it has it). >> >> Please let us know if this makes a difference. >> >> HTH, >> Jamal >> >> >> "D.J.W. van Kooten" wrote in message >> 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 | 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