Success !! (was RE:Indexed or Seq?)

[fernando.olmos at hpa.com.au]

Thanks Darren/et al,

Mind you, I have yet to present the case to my supervisors, because to
get the before/after reports I have to run the original program in a
test environment with a big enough spread of data. Unfortunately I just
came into the office this morning and found I have filled up the entire
test server's disk space!! The program was trying to sort over 6 million
records (3 million per table) each with a size of around 600 bytes.
That's a sort file of the size close to 1,757,812.5 kilobytes or over
1.5 gig! I don't know what the partition size is, but it does not sound
that it's too big to handle a sort file this big. How can I find that
out in UNIX? I am a VMS man personally! (*wink*).

Cheers

-----Original Message-----
From: darren.reely at latticesemi.com [mailto:darren.reely at latticesemi.com]

Sent: Thursday, August 25, 2005 4:40 AM
To: Fernando Olmos; powerh-l at lists.sowder.com
Subject: Re: Success !! (was RE:Indexed or Seq?)


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):   ....
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended solely for the use of the individual or entity to whom they are addressed.  If you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au, then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the presence of computer viruses by MimeSweeper.  Before opening or using any attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more information about use, disclosure and access see our Privacy Policy at www.hpa.com.au
**********************************************************************