Oracle /Perl Access Speed Optimization

[Bharat]

Hi ,

I am using perl 5.6 with Oracle 8i on redhat Linux 7.2 system, Iam facing probelm in speed of processing records,
I have around 30K records sets ( 1 record set means records from 30 table) now in the database
(can go upto 80K) .
my Existing program is taking 16 hrs to read these set and create an XML and / Excel file.
I am preparing set of queries at the begining and executing it with parameters for every Record set.
which returns array of hash references for all records per record set and then I am writing to either XML/Excel file.

Can it be possible to reduce this processing time ?
Also , Will stored procedure help in this case and how do I use it (pl mention sample code) ?



Bharat



Bharat Badhe