Bharat, first two important notices from Oracle tuning guides :
"If you want to tune your database, don't do it" "If you want to increase performance, you have to find the bottleneck" Next a few hints where you can start tuning your database : use "explain plan"(see Oracle docs) to see wether your sql queries use indexes or do full table scans. If they do full table scans on large tables, create indexes for these fields. Find out, what queries cause the slowliness and try to tune sql. Switch on statistics in your database and analyze results. Set optimizer to Cost based. There's a lot more about Oracle tuning, but this should be enough to start. Knut -----Original Message----- From: Bharat [mailto:bgbadhe@;rediffmail.com] Sent: Saturday, October 26, 2002 8:56 AM To: [EMAIL PROTECTED] Subject: Oracle /Perl Access Speed Optimization 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
