RE: Re: Re: RE: Perl Question: Optimization

2004-11-05 Thread Jeffrey . Seger
__ "CAMPBELL, BRIAN D (BRIAN)" <[EMAIL PROTECTED]> 11/04/2004 01:31 PM To: Jeffrey Seger/Corporate/[EMAIL PROTECTED], "Sunil A.V." <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Subject:RE: Re: Re: RE: Perl Question: Optim

RE: Re: Re: RE: Perl Question: Optimization

2004-11-04 Thread CAMPBELL, BRIAN D (BRIAN)
rself, the code needs to be tweaked, and you'd pretty much be doing the work of prepare_cached anyway. -Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, November 04, 2004 10:21 AM To: Sunil A.V. Cc: [EMAIL PROTECTED] Subject: Re: Re: Re: RE: Perl Qu

Re: Re: Re: RE: Perl Question: Optimization

2004-11-04 Thread Jeffrey . Seger
quot;Sunil A.V." To: [EMAIL PROTECTED] cc: Jeffrey Seger/Corporate/[EMAIL PROTECTED] Subject:Re: Re: Re: RE: Perl Question: Optimization Partly right. Here is the code snippet. #! /opt/perl5/bin/perl use strict; use DBI; my $datasource = "dbi:Oracle:&

Re: Re: Re: RE: Perl Question: Optimization

2004-11-04 Thread Sunil A.V.
s on the same db handle, but it will cut >down on the number of prepares you ahve to do dramatically. > >If you can't have multiple statement handles on one DB handle, then you >could create a @dbh array as well. > > > > >Jeff Seger >Fairchil

RE: Re: RE: Perl Question:

2004-11-03 Thread bruce
sunil do me a favor... give me what you said in psuedo code... show me your logic in a rough code/logic flow.. thanks.. -bruce -Original Message- From: Sunil A.V. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 9:47 AM To: [EMAIL PROTECTED] Subject: Re: Re: RE: Perl

Re: Re: RE: Perl Question:

2004-11-03 Thread Jeffrey . Seger
__ "Sunil A.V." <[EMAIL PROTECTED]> 11/03/2004 12:47 PM Please respond to "Sunil A.V." To: [EMAIL PROTECTED] cc: Subject:Re: Re: RE: Perl Question: Hi all, I have put this followup question to my previous question [might

Re: Re: RE: Perl Question:

2004-11-03 Thread Sunil A.V.
Hi all, I have put this followup question to my previous question [might have been hidden in my previous email]. FOLLOWUP QUESTION: I have a data file with about 4 rows. Each row has a material name. I will have to fetch about 10 attributes depending on this material name. So I have 10 quer