You need to isolate where the slowness is. It might be your perl code, it might be the database, it might be the drivers or network.
Tim. On Sat, Oct 26, 2002 at 06:56:28AM -0000, Bharat wrote: > > 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
