On Thu, 2005-05-12 at 07:48, Job Miller wrote:
>
> a 20k row fetch via an index would be a bad idea.
Without knowing more about the data and schema, you
can't really claim that.
If the 20k rows are from a billion row table that is
not partitioned, an index may be a good idea.
It depends on h
On Thu, 2005-05-12 at 07:21, Ian Harisay wrote:
> If this takes 2 minutes then your problem is with your database, not
> Perl. Which means you'll need to look at query optimization. Not code
> optimization. Your query optimization may also include tuning your database.
Things like network laten
Look like problem lies with the Database Query. To
check run the query from SQL prompt and checkout the
time taken by the query(From ur explanation,seems
query is taking two minutes). If the query is taking
more time, then try indexing where clause columns
--- Divya <[EMAIL PROTECTED]> wrote:
>
the benefit to having oracle in this case is that I don't have to do this
manual timing stuff or even sql*plus timing. trace the session at the database
level and it will tell you everything you need to know about where the problem
lies with no speculation required.
it will tell you what if
On Thu, May 12, 2005 at 07:43:41PM +0530, Divya wrote:
> a) We are using Oracle 8i DB. The query (or the DBMS) takes only 6 seconds
> to return data to Perl.
>
> c) So we conclude that it is mainly an issue with fetchrow especially when
> the number of records are high. We tried other possible opt
it.
-Original Message-
From: JupiterHost.Net [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 10:33 AM
To: dbi-users@perl.org
Subject: Re: Perl Performance Help.
> a) We are using Oracle 8i DB.
> The query (or the DBMS) takes only 6 seconds
> to return data to Perl.
How di
Divya,
Here are some of the statistics :
a) We are using Oracle 8i DB. The query (or the DBMS) takes only 6 seconds
to return data to Perl.
So the query execution takes 6 seconds... How long does it take to get
all the rows back in sqlplus (I mean how long does it take for sqlplus to get
all 20K
a) We are using Oracle 8i DB.
> The query (or the DBMS) takes only 6 seconds
to return data to Perl.
How did you determine this? I think you're just assuming that.
c) So we conclude that it is mainly an issue with fetchrow especially when
the number of records are high. We tried other possible opt
, we cannot have
> mod_perl installed on the
> server.
>
> Can you please suggest if we have more options.
>
> Thanks & rgds
> -Divya
>
>
> -----Original Message-----
> From: Jonathan Leffler
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 12, 2005 6:01
installed on the
server.
Can you please suggest if we have more options.
Thanks & rgds
-Divya
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 6:01 PM
To: Divya
Cc: dbi-users@perl.org
Subject: Re: Perl Performance Help.
On 5/12/05, Divya &
e SQL statement.
-Will
-Original Message-
From: Divya [mailto:[EMAIL PROTECTED]
Sent: Thursday 12 May 2005 07:58
To: dbi-users@perl.org
Subject: Perl Performance Help.
Hi All,
I am in a Perl based project, where we fire a query which returns 20K
records.
In the perl side, we us
se suggest if we have more options.
Thanks & rgds
-Divya
-Original Message-
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 6:01 PM
To: Divya
Cc: dbi-users@perl.org
Subject: Re: Perl Performance Help.
On 5/12/05, Divya <[EMAIL PROTECTED]> wrote:
is very efficient. My experience is with Oracle and MySQL.
The DBDs for these DBs seems quite efficient to me.
-Ian
-Original Message-
From: Divya [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 5:58 AM
To: dbi-users@perl.org
Subject: Perl Performance Help.
Hi All,
I am in
On 5/12/05, Divya <[EMAIL PROTECTED]> wrote:
> I am in a Perl based project, where we fire a query which returns 20K
> records.
> In the perl side, we use the following snippet to get the query result to an
> array.
>
> while ( @each_record = $stmt_handle->fetchrow)
>
> {
> push @records, [ @eac
Divya wrote:
Hi All,
I am in a Perl based project, where we fire a query which returns 20K
records.
In the perl side, we use the following snippet to get the query result to an
array.
while ( @each_record = $stmt_handle->fetchrow)
{
push @records, [ @each_record ] ;
}
So you end up wit
Hi All,
I am in a Perl based project, where we fire a query which returns 20K
records.
In the perl side, we use the following snippet to get the query result to an
array.
while ( @each_record = $stmt_handle->fetchrow)
{
push @records, [ @each_record ] ;
}
Upon analysis, we fou
16 matches
Mail list logo
