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
<!--{cke_protected}{C}%3C!%2D%2D%0A%2F*%20Font%20Definitions%20*%2F%0A%40font-face%0A%09%7Bfont-family%3ACalibri%3B%0A%09panose-1%3A2%2015%205%202%202%202%204%203%202%204%3B%0A%09mso-font-charset%3A0%3B%0A%09mso-generic-font-family%3Aswiss%3B%0A%09mso-font-pitch%3Avariable%3B%0A%09mso-font-signature%3A-536870145%201073786111%201%200%20415%200%3B%7D%0A%40font-face%0A%09%7Bfont-family%3ATahoma%3B%0A%09panose-1%3A2%2011%206%204%203%205%204%204%202%204%3B%0A%09mso-font-charset%3A0%3B%0A%09mso-generic-font-family%3Aswiss%3B%0A%09mso-font-pitch%3Avariable%3B%0A%09mso-font-signature%3A-520081665%20-1073717157%2041%200%2066047%200%3B%7D%0A%40font-face%0A%09%7Bfont-family%3AConsolas%3B%0A%09panose-1%3A2%2011%206%209%202%202%204%203%202%204%3B%0A%09mso-font-charset%3A0%3B%0A%09mso-generic-font-family%3Amodern%3B%0A%09mso-font-pitch%3Afixed%3B%0A%09mso-font-signature%3A-520092929%201073806591%209%200%20415%200%3B%7D%0A%2F*%20Style%20Definitions%20*%2F%0Ap.MsoNormal%2C%20li.MsoNormal%2C%20div.MsoNormal%0A%09%7Bmso-style-unhide%3Ano%3B%0A%09mso-style-qformat%3Ayes%3B%0A%09mso-style-parent%3A%22%22%3B%0A%09margin%3A0in%3B%0A%09margin-bottom%3A.0001pt%3B%0A%09mso-pagination%3Awidow-orphan%3B%0A%09font-size%3A11.0pt%3B%0A%09font-family%3A%22Calibri%22%2C%22sans-serif%22%3B%0A%09mso-ascii-font-family%3ACalibri%3B%0A%09mso-fareast-font-family%3ACalibri%3B%0A%09mso-hansi-font-family%3ACalibri%3B%0A%09mso-bidi-font-family%3A%22Times%20New%20Roman%22%3B%7D%0Aa%3Alink%2C%20span.MsoHyperlink%0A%09%7Bmso-style-noshow%3Ayes%3B%0A%09mso-style-priority%3A99%3B%0A%09color%3Ablue%3B%0A%09text-decoration%3Aunderline%3B%0A%09text-underline%3Asingle%3B%7D%0Aa%3Avisited%2C%20span.MsoHyperlinkFollowed%0A%09%7Bmso-style-noshow%3Ayes%3B%0A%09mso-style-priority%3A99%3B%0A%09color%3Apurple%3B%0A%09text-decoration%3Aunderline%3B%0A%09text-underline%3Asingle%3B%7D%0Ap.MsoPlainText%2C%20li.MsoPlainText%2C%20div.MsoPlainText%0A%09%7Bmso-style-priority%3A99%3B%0A%09mso-style-link%3A%22Plain%20Text%20Char%22%3B%0A%09margin%3A0in%3B%0A%09margin-bottom%3A.0001pt%3B%0A%09mso-pagination%3Awidow-orphan%3B%0A%09font-size%3A11.0pt%3B%0A%09mso-bidi-font-size%3A10.5pt%3B%0A%09font-family%3A%22Calibri%22%2C%22sans-serif%22%3B%0A%09mso-fareast-font-family%3ACalibri%3B%0A%09mso-bidi-font-family%3AConsolas%3B%7D%0Ap.MsoAcetate%2C%20li.MsoAcetate%2C%20div.MsoAcetate%0A%09%7Bmso-style-noshow%3Ayes%3B%0A%09mso-style-priority%3A99%3B%0A%09mso-style-link%3A%22Balloon%20Text%20Char%22%3B%0A%09margin%3A0in%3B%0A%09margin-bottom%3A.0001pt%3B%0A%09mso-pagination%3Awidow-orphan%3B%0A%09font-size%3A8.0pt%3B%0A%09font-family%3A%22Tahoma%22%2C%22sans-serif%22%3B%0A%09mso-fareast-font-family%3ACalibri%3B%7D%0Aspan.PlainTextChar%0A%09%7Bmso-style-name%3A%22Plain%20Text%20Char%22%3B%0A%09mso-style-priority%3A99%3B%0A%09mso-style-unhide%3Ano%3B%0A%09mso-style-locked%3Ayes%3B%0A%09mso-style-link%3A%22Plain%20Text%22%3B%0A%09mso-bidi-font-size%3A10.5pt%3B%0A%09font-family%3A%22Calibri%22%2C%22sans-serif%22%3B%0A%09mso-ascii-font-family%3ACalibri%3B%0A%09mso-hansi-font-family%3ACalibri%3B%0A%09mso-bidi-font-family%3AConsolas%3B%7D%0Aspan.BalloonTextChar%0A%09%7Bmso-style-name%3A%22Balloon%20Text%20Char%22%3B%0A%09mso-style-noshow%3Ayes%3B%0A%09mso-style-priority%3A99%3B%0A%09mso-style-unhide%3Ano%3B%0A%09mso-style-locked%3Ayes%3B%0A%09mso-style-link%3A%22Balloon%20Text%22%3B%0A%09mso-ansi-font-size%3A8.0pt%3B%0A%09mso-bidi-font-size%3A8.0pt%3B%0A%09font-family%3A%22Tahoma%22%2C%22sans-serif%22%3B%0A%09mso-ascii-font-family%3ATahoma%3B%0A%09mso-hansi-font-family%3ATahoma%3B%0A%09mso-bidi-font-family%3ATahoma%3B%7D%0A.MsoChpDefault%0A%09%7Bmso-style-type%3Aexport-only%3B%0A%09mso-default-props%3Ayes%3B%0A%09font-family%3A%22Calibri%22%2C%22sans-serif%22%3B%0A%09mso-ascii-font-family%3ACalibri%3B%0A%09mso-fareast-font-family%3ACalibri%3B%0A%09mso-hansi-font-family%3ACalibri%3B%0A%09mso-bidi-font-family%3A%22Times%20New%20Roman%22%3B%7D%0A%40page%20WordSection1%0A%09%7Bsize%3A8.5in%2011.0in%3B%0A%09margin%3A1.0in%201.0in%201.0in%201.0in%3B%0A%09mso-header-margin%3A.5in%3B%0A%09mso-footer-margin%3A.5
in%3B%0A%09mso-paper-source%3A0%3B%7D%0Adiv.WordSection1%0A%09%7Bpage%3AWordSection1%3B%7D%0A%2D%2D%3E-->
--
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.
