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 | Sat, 02 Feb 2013 09:27:05 +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> |
| Lines | 75 |
| NNTP-Posting-Host | 188.115.10.103 |
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!newsfeed.straub-nv.de!news.albasani.net!newsfeed.freenet.ag!news2.euro.net!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!news.vo.lu!not-for-mail |
| Newsgroups | comp.lang.clipper.visual-objects |
| X-Trace | vo.lu 1359794281 188.115.10.103 (2 Feb 2013 09:38:01 0100) |
| User-Agent | Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130107 Thunderbird/17.0.2 |
| MIME-Version | 1.0 |
| To | Jamal <vodotnet_nospam@yahoo.com> |
| In-Reply-To | <kehhpa$g6n$1@dont-email.me> |
| Content-Type | text/plain; charset=ISO-8859-1; format=flowed |
| Content-Transfer-Encoding | 7bit |
| Xref | csiph.com comp.lang.clipper.visual-objects:4710 |
Show key headers only | View raw
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