What happens with Apache::DBI?
-Original Message-
From: David Nicol [mailto:davidni...@gmail.com]
Sent: Tuesday, July 12, 2011 12:00 PM
To: ZhangJun
Cc: dbi-users@perl.org
Subject: Re: is it possible to use two sth from same dbh at the same time ?
when it isn't possible, you can create
Try doing a very simple refcursor and see if you still have the same
performance issues.
John
From: P S Jameel Ahamed [mailto:jaha...@idexcel.com]
Sent: Wednesday, May 18, 2011 5:04 AM
To: 'John Scoles'; 'Martin Evans'; dbi-users@perl.org; Carlson, John W.; 'Tim
Bunce'
Subject: RE: (Fwd) Re
When I say simple, I mean on a table with just a few rows. You may want to
look at how many rows are pulled back from the database at a time on your large
table (batching rows).
John
-Original Message-
From: Carlson, John W. [mailto:carlso...@llnl.gov]
Sent: Wednesday, May 18, 2011 9
It looks like you're doing a full table scan to pull back all rows of
tbl_qm_dashboard currently--how many rows does that have?
-Original Message-
From: Carlson, John W. [mailto:carlso...@llnl.gov]
Sent: Wednesday, May 18, 2011 10:05 AM
To: P S Jameel Ahamed; 'John Scoles'; 'Martin
Don't use dynamic queries? You can use PL/SQL variables directly in the SQL
statement w/o specifying them as bind variables. That is, pass them as
parameters to your stored procedure, then just put them directly in the SQL
without decoration. Return XML CLOB instead of cursor?
Just some
What is the recommended DBD::Oracle version and which instant client should I
compile against for Oracle 11g databases, RedHat el5xen Linux x86_64 (64bit)
architecture? There appears to be several recent oddly named versions on CPAN.
1.26 is out there, but it doesn't appear to be the latest
We have a lot of similar queries (see attached) that return a non-unique
identifier and two varrays. One varray is a timestamp array and the other is a
float value array. See attached SQL. We are currently returning on the order
of 1600 rows. We would like to change the settings in
Would it be possible to install DBI DBD::Oracle in your home folder and test
there?
John
-Original Message-
From: pDale [mailto:pda...@gmail.com]
Sent: Monday, April 19, 2010 7:33 AM
To: newbie01 perl
Cc: beginn...@perl.org; dbi-users
Subject: Re: Help on using on *nix and Windows
Uh. I just installed DBD::Oracle 1.23 with a patch. Should I install
DBD::Oracle 1.22 instead? What I the nature of the bug?
I am fairly new to the dbi-users group, and I haven't been watching the emails.
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent:
So far, I am read only!
Thanks,
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 05, 2010 9:31 AM
To: Carlson, John W.
Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com
Subject: Re: dbd::oracle behavior
The bug in 1.23 will hit
To: Carlson, John W.
Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com
Subject: Re: dbd::oracle behavior
should be no problem then what was the original version of DBD:Oracle
and DBI where you using??
So far, I am read only!
Thanks,
John
-Original Message-
From: John Scoles
There is a problem with that file. It looks like it's compressed twice.
John
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 05, 2010 10:07 AM
To: Carlson, John W.
Cc: Matthew Maglinte; dbi-users@perl.org; tim.bu...@pobox.com
Subject: Re: dbd
Would this help? Note the precision on the timestamp.
CREATE OR REPLACE TYPE ARCHIVE.VOLTAGE_TIMESTAMP_ARRAY AS VARRAY(200) OF
TIMESTAMP(6);
From: John Scoles [mailto:byter...@hotmail.com]
Sent: Thursday, January 28, 2010 5:04 PM
To: Carlson, John W.; dbi-users@perl.org
Subject: RE: selecting
...@pythian.com]
Sent: Thursday, February 04, 2010 11:24 AM
To: Carlson, John W.
Cc: John Scoles; dbi-users@perl.org
Subject: Re: selecting millisecond or microsecond accuracy from varray of
timestamps
that should be fix with the small patch I provied the other days
or you can get the latest Trunk version
We have an oracle type,
CREATE OR REPLACE TYPE ARCHIVE.VOLTAGE_TIMESTAMP_ARRAY AS VARRAY(200) OF
TIMESTAMP;
We would like to get millisecond or microsecond accuracy out of these
timestamps. We are currently using DBD::Oracle 1.21. Here is a sample query,
with several varrays rows being
15 matches
Mail list logo