<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
> replaces the "fetch")
>-- do all the "cursor" loop stuff
>set var vcount = (.vcount + 1)
>goto top
>
> I don't know if this will speed up the code, but it prevents the routine from
> putting ANY locks on the main table.
>
> Karen
>
>
&
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-
I would find out why the while loop never completes. I have 9 level while loops
for my BOM to break down the assemblies into a parts list that runs every night
and it always runs.
There are many tricks on speeding up processing. Sometimes using temp tables to
reduce the amount of items in the
20 matches
Mail list logo
