<rbase-l@googlegroups.com>
Sent: Fri, Apr 28, 2017 8:24 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Karen, I wonder if SET ZERO ON/OFF has different results with the two selects.
Inquiring minds want to know — well, mine anyway.
Albert
On Apr 25, 2017, at 3:12 PM,
" would have
returned.
Nope, I looked, I can't find a copy of the program from pre-2014. So I'd have
to reconstruct the while loop.
Karen
-Original Message-
From: Javier Valencia <javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tu
ned.
Nope, I looked, I can't find a copy of the program from pre-2014. So I'd have
to reconstruct the while loop.
Karen
-Original Message-
From: Javier Valencia <javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, Apr 25, 2017 1:30 pm
Su
the code used to run fast in 9.5, they
do the "if it ain't broke".
Karen
-Original Message-
From: Javier Valencia <javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, Apr 25, 2017 12:30 pm
Subject: RE: [RBASE-L] - Thoughts on
@googlegroups.com
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Thanks, Javier, all good thoughts.
Quick question: If I am dialing into the system using Remote Desktop (no VPN,
not dialed into the database server itself), am I seeing the same performance
as a person on a network
d the fortitude to read my verbose email
Karen
-Original Message-
From: Javier Valencia
<javier.valen...@vtgonline.com><mailto:javier.valen...@vtgonline.com>
To: rbase-l <rbase-l@googlegroups.com><mailto:rbase-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 3:05
3-915-3137
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Monday, April 24, 2017 1:05 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Yeah, I'll try to trace the program while everyone is connected and see if I
can pinpoint any
, April 24, 2017 1:05 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Yeah, I'll try to trace the program while everyone is connected and see if I
can pinpoint any particular commands that seem like they take longer than they
"should". The
e-l@googlegroups.com]
Sent: Monday, April 24, 2017 11:05 AM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Yeah, I'll try to trace the program while everyone is connected and see if I
can pinpoint any particular commands that
, 2017 11:05 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Yeah, I'll try to trace the program while everyone is connected and see if I
can pinpoint any particular commands that seem like they take longer than they
"should". The
ts trying to explain what's going on, I could probably even get it down
to 300 lines!
Karen
-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 11:56 am
Subject: RE: [RBASE-L] - Thoughts on sp
ooglegroups.com><mailto:rbase-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 11:32 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Karen - I had a similar speed question when using the UPDATE command on 2/3/15,
although my questions was more about optimal use of the WHERE clause tha
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
Doug Hamilton
Sent: Monday, April 24, 2017 9:53 AM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Hard to believe? No, just proves that sending guys to the moon is easier than
-Original Message-
From: Doug Hamilton <bugl...@wi.rr.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 11:32 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Karen - I had a similar speed question when using the UPDATE command
on 2/3/15, although
ren
>
>
>
> -Original Message-
> From: Albert Berry <alb...@albertberry.com>
> To: rbase-l <rbase-l@googlegroups.com>
> Sent: Mon, Apr 24, 2017 9:40 am
> Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
>
> Karen - wild thought. Would a compoun
Karen
-Original Message-
From: Albert Berry <alb...@albertberry.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 9:40 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Karen - wild thought. Would a compound index work here?
CREATE INDEX
se-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 9:40 am
Subject: Re: [RBASE-L] - Thoughts on speeding up a cursor?
Karen - wild thought. Would a compound index work here?
CREATE INDEX LoopTroubles (PolicyID,AgentNo,Policy,CovCode)
This would enable an index only retrieval.
Albert
On Apr 24
tmpagtcomm +
> WHERE agentno = .vagentno AND policy_no = .vpolicy_no +
> AND covcode = .vcovcode
>
> This way it is not looking at all the where parameters which might slow it
> down.
>
> Not sure if this helps. I usually trace it as well to see what is
ow if this will speed up the code, but it prevents the routine from
putting ANY locks on the main table.
Karen
-Original Message-
From: Dan Goldberg <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Mon, Apr 24, 2017 8:34 am
Subject: RE: [RBASE-
e-l@googlegroups.com]
Sent: Monday, April 24, 2017 6:14 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Thoughts on speeding up a cursor?
I inherited a monster program. It's 800 physical lines of code, separated like
this:
100 lines of pre-processing code before we set a cursor
600 lines of c
20 matches
Mail list logo