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 workstation? If not, then that screws up my ability to test speed

RE: [RBASE-L] - Thoughts on speeding up a cursor?

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

RE: [RBASE-L] - Thoughts on speeding up a cursor?

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

RE: [RBASE-L] - Thoughts on speeding up a cursor?

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,

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 only issue is that depending on the particular data, it will be processing just a small percentage of the entire 600 lines

Re: [RBASE-L] - Thoughts on speeding up a cursor?

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

RE: [RBASE-L] - Thoughts on speeding up a cursor?

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

Re: [RBASE-L] - Thoughts on speeding up a cursor?

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

Re: [RBASE-L] - Thoughts on speeding up a cursor?

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 >

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 than GOTO and labels. You, Dennis and others offered many helpful answers. If you think optimizing the DECLARE CURSOR would help, here is the

Re: [RBASE-L] - Thoughts on speeding up a cursor?

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

AW: [RBASE-L] - issue with receipt printer

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

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, 2017, at 8:26 AM, karentellef via RBASE-L > wrote: > > Dan: > > I had actually posted

Re: [RBASE-L] - Thoughts on speeding up a cursor?

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

RE: [RBASE-L] - Thoughts on speeding up a cursor?

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