Success !! (was RE:Indexed or Seq?)
Darren Reely
darren.reely at latticesemi.com
Wed Aug 24 13:39:48 CDT 2005
Fernando,
That is a _VERY_ dramatic run time difference. Congradulations!
Thanks for the response and the kudos. It is nice to see the results
people can get from the list.
Darren
fernando.olmos at hpa.com.au wrote:
> Bob, Darren, Joe and Conrad:
>
> I have finished the project and I have made huge in-roads into the
> performance issues with this particular program. In short, the program
> took over 12 HOURS to run on some end of months, and I have reduced it
> to under 10 minutes!! Thank God for SQL cursors!
>
> Here are the times from the original batch run (only one of the QUIZ
> programs I changed): ....
More information about the powerh-l
mailing list