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]<mailto:[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 -- 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]<mailto:[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.
