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 workstation? If not, then that screws up my ability
to test speed
I think you have gotten several good answers already but this is what I know
based on my experience.
Indexes – I had an application that generated random inspection location for a
large number of records and ran relatively quick. Then it started to run very
slowly and I could not figure out
Karen,
I definitely have NEVER dealt with the table size you’re looking at but
creating temp tables with filters in decreasing impact value usually brings the
best/fastest results.
In your case, I would start with a date field or the one field that is most
often not null choosing whichever
I do not use label-goto commands that much but have not noticed a speed impact
on the ones I have used them in.
Sometimes for me is just looking at it and finding a better way to accomplish
it works.
Dan
From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Monday, April 24,
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 only issue is that depending on the particular data, it will be
processing just a small percentage of the entire 600 lines
Karen,
This is the sort of time when it could be useful to be able to see TRACE
scrolling through on screen when running to next error or, in your case just
running to the end. You might then be able to see where it slows down or takes
time over a particular line.
Regards,
Alastair.
On
Depending on the size of the tables and the complexity of the where clause
sometimes temp tables will speed it up tremendously. I use them throughout my
programming to speed up different things.
Tracing usually shows me which one is slowing it down and that is where I look
at.
Dan Goldberg
Hard to believe? No, just proves that sending guys to the moon is
easier than figuring out insurance stuff. :)
D
On 4/24/2017 11:37 AM, karentellef via RBASE-L wrote:
Here's the thing -- believe it or not, there is NOT A SINGLE PLACE in
that 600 lines of cursor where I am _updating_ a
I think using the compounds would allow you to pick up the values from the
index (index only retrieval) and then the code wouldn’t have to actually
retrieve the data from file 2 for some of the selects.
Albert
> On Apr 24, 2017, at 8:50 AM, karentellef via RBASE-L
>
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 than GOTO and labels. You, Dennis and others offered many
helpful answers.
If you think optimizing the DECLARE CURSOR would help, here is the
That select statement is not my cursor, that's just one of the many 600 lines
of code that the cursor is evaluating. The cursor itself would not be
index-able as it contains >=, not null, etc
I mean, yes, I could look at the many, many select statements within the loop
(my wild guess is
Steve,
thank you for your advice. There are many thing to be tested. Actually no
success with USB2, but connected with USB3 there are no problems!
Armin
Von: rbase-l@googlegroups.com im Auftrag von Steve
Johnson
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, 2017, at 8:26 AM, karentellef via RBASE-L
> wrote:
>
> Dan:
>
> I had actually posted
Dan:
I had actually posted here on the list a few years ago when, as the business
grew, our cursor (which used to process about 25K rows) started randomly
crashing in the 30K or 40K range. Several people here recommended to replace
the while loop with goto/label, so that's what I did. The
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
15 matches
Mail list logo