I think you converted me to Jeff’s idea during my Chicago days. Albert > On Jan 21, 2019, at 8:50 AM, 'Karen Tellef' via RBASE-L > <rbase-l@googlegroups.com> wrote: > > 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 <d...@lancecamper.com <mailto:d...@lancecamper.com>> > To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> > <rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>> > 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" > <j...@jjcalibrations.com <mailto:j...@jjcalibrations.com>> 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 > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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 rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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 rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <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 rbase-l+unsubscr...@googlegroups.com > <mailto:rbase-l+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <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 rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.