I don't know if any of you remember Jeff Ward, I worked with him on RBase projects in the 90s, and he and I were the co-chairs of the Chicago Area RBase Users Group (CARBUG) Anyway, at one of our meetings he put out a challenge that he could replace any Declare Cursor with a series of SQL commands (update and such) and have the SQL work perform faster. People brought examples and he was able to convert each one if I remember correctly.
In case you knew Jeff, he quit all programming years ago, made a bit of money inventing the Lapinator (one of the first laptop "desks" of which his website named me as the muse for the idea). He is heavy into local politics here in the Chicago area, has been jailed by the political folk he routinely ticks off (altho he welcomes it because his jail posts are priceless), has his own political blog, is a columnist in local papers, or you can search Facebook for the "Curmudgeon Book Club" Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: [email protected] <[email protected]> Sent: Sun, Jan 20, 2019 4:10 pm Subject: Re: [RBASE-L] - Code update I use temp tables alot to speed up processing and view usage. They make a huge difference! Daniel Goldberg Mis Manager Lance Camper On Sat, Jan 19, 2019 at 3:47 PM -0800, "jan johansen" <[email protected]> wrote: All, I've been tasked with going through all old code looking for areas to improve. One area is evaluating and updating cursors. Old code ran a cursor and took 63 seconds.New code runs temporary tables and select update and now takes 2 seconds. It's a win. Jan #yiv0335243574 #yiv0335243574 -- _filtered #yiv0335243574 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0335243574 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv0335243574 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #yiv0335243574 #yiv0335243574 p.yiv0335243574MsoNormal, #yiv0335243574 li.yiv0335243574MsoNormal, #yiv0335243574 div.yiv0335243574MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;} #yiv0335243574 a:link, #yiv0335243574 span.yiv0335243574MsoHyperlink {color:blue;text-decoration:underline;} #yiv0335243574 a:visited, #yiv0335243574 span.yiv0335243574MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv0335243574 p.yiv0335243574MsoPlainText, #yiv0335243574 li.yiv0335243574MsoPlainText, #yiv0335243574 div.yiv0335243574MsoPlainText {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;} #yiv0335243574 p.yiv0335243574MsoAcetate, #yiv0335243574 li.yiv0335243574MsoAcetate, #yiv0335243574 div.yiv0335243574MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;} #yiv0335243574 span.yiv0335243574PlainTextChar {} #yiv0335243574 span.yiv0335243574BalloonTextChar {} #yiv0335243574 .yiv0335243574MsoChpDefault {} _filtered #yiv0335243574 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv0335243574 div.yiv0335243574WordSection1 {} #yiv0335243574 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
