Re: Oracle /Perl Access Speed Optimization

2002-10-30 Thread Jared Still
of good hints, maybe sometimes a little bit more honestly. Regards Knut -Original Message- From: Tim Bunce [mailto:Tim.Bunce;pobox.com] Sent: Sunday, October 27, 2002 7:16 PM To: Knut Herzog Cc: 'Bharat'; [EMAIL PROTECTED] Subject: Re: Oracle /Perl Access Speed Optimization

Re: Oracle /Perl Access Speed Optimization

2002-10-30 Thread Tim Bunce
On Wed, Oct 30, 2002 at 07:04:07AM -0800, Jared Still wrote: The methods found in there are endorsed by the likes of Cary Millsap, Anjo Kolk, Jonathan Lewis, Mogens Norgaard and many others. I believe that Cary Millsap wrote the forward, though I don't have the book in front of me right

Re: Oracle /Perl Access Speed Optimization

2002-10-28 Thread Michael A Chase
On 26 Oct 2002 06:56:28 - Bharat [EMAIL PROTECTED] wrote: 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

Re: Oracle /Perl Access Speed Optimization

2002-10-27 Thread Tim Bunce
: 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

Re: Oracle /Perl Access Speed Optimization

2002-10-27 Thread Tim Bunce
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 -, Bharat wrote: Hi , I am using perl 5.6 with Oracle 8i on redhat Linux 7.2 system, Iam facing probelm

RE: Oracle /Perl Access Speed Optimization

2002-10-27 Thread Knut Herzog
To: Knut Herzog Cc: 'Bharat'; [EMAIL PROTECTED] Subject: Re: Oracle /Perl Access Speed Optimization Oracle performance tuning made easy: Step 1: Buy this book... Oracle Performance Tuning 101 By Gaja Krishna Vaidyanatha, John A. Kostelac, Kirtikumar Deshpande Oracle Press

Oracle /Perl Access Speed Optimization

2002-10-26 Thread 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

RE: Oracle /Perl Access Speed Optimization

2002-10-26 Thread Knut Herzog
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