Please read the documentation for Apache::DBI.
In Apache 1.3 and mod_perl 1.xx, when using Apache::DBI in conjunction
with DBI you get the following:
Each Apache process runs one perl instance. Each perl instance loads up
one instance of Apache::DBI. Each instance of Apache::DBI automatically
'
Dan,
The server and all the SP's I am running this on is MSSQL and not Sybase. I
have another DSN to a Sybase server and tested this behavior on that one,
and reported the results here. I was hoping to find someone who knew the
ODBC driver guts well enough to know what the problem was or knew a
s
James
if you think it's a DBD::ODBC issue, why not use DBD::Sybase instead?
Dan
"Moosmann, James" <[EMAIL PROTECTED]>
19/10/2004 16:17
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, (bcc: Dan
Horne/IT/AKLWHG/WHNZ)
Jeff,
It is VERY VALID syntax for both MSSQL ... AND.. Sybase. I have been coding
in Perl and DBI for several years now and I am NOT trying to use the perl
print function. Here is the skinny on PRINT direct from our DBA for MSSQL
Server PRINT :
The PRINT statement takes either one character
my $sql = qq#
PRINT 'starting select'
select count(*) from anytable
PRINT 'finished'
#;
is not valid sql.
try this:
my $sql = qq#
select count(*) from anytable
#;
my $sth = $dbh->prepare( $sql );
print 'starting select';
my $rv = $sth->execute();
while ( my $hr = $sth->fetchrow_hashref ){
Paul,
Without knowing much about Oracle (although I can talk your ear off about Sybase), you
want to "cache" connections to the server and set a limit (maybe its 1!) and use this
pool of connections to connect to your server.
Major advantage:
No overhead for creating the connection on star
I realize I may not have been totally clear in my earlier post, which
should have said:
My CGI application will be called by different visitors to the web
site at different times, but they all connect to the same database
using the same connection variables, i.e. the same user/password.
Are y
No reauthenticate() method in DBD:Oracle v 1.12 or in the ActiveState
Perl 5.6 docs.
Is there a Windows IIS equivalent for the Apache::DBI for persistent
connections?
Is there a way to configure or set Oracle form its Enterprise
Management Console to establish a persistent connection to a
par
On Mon, Oct 18, 2004 at 04:39:25PM -0400, Paul Appleby wrote:
> My CGI application will be called by different users at different
> times. Are you saying the first user's connection can be left open
> for all the other users? How?
Apart from the other (good) advice here, which you should follow
I am using DBI and DBD-ODBC to connect to an MSSQL Server and this query
gets an invalid cursor state:
PRINT 'starting select'
select count(*) from anytable
PRINT 'finished'
If I only run the PRINT command... it works.
If I run the full query against a sybase server... only the top select
prints
On Mon, 18 Oct 2004 19:24:03 +0100, Tim Bunce wrote:
Hi Tim
> Can't be
> web-based.
Oh :-((.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/10/2004
http://savage.net.au/index.html
On Mon, 18 Oct 2004 16:51:35 +0200 (CEST), Raphael wrote:
Hi Raphael
> ppm install DBI.ppd
> Error : no suitable installation target
It's been years since I had this problem, so I'm really guessing, but I think it's due
to a conflict between the Perl you are using and the Perl used to prepare t
I have a DBIx::HA (High Availability) module on CPAN, but I'm readying
a next version real soon now that will take care of this for you.
If you combine Apache+mod_perl+Apache::DBI+DBIx::HA, you'll get what
you need.
I'm debugging one last instance of a dbh having an ActiveKid handle
when it s
H...one thing I thought of is to check the validity of the handle, in case the
Oracle instance bounces (i.e. The Oracle instance is available, but the persistent
connection no longer exists). Does that automagically happen in the connect or should
there be code to check for a specific erro
Look at using Apache::DBI for persistent connections.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Paul Appleby [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 2:39 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection
No. Each user will be using the same application that logs in to the
same schema. But the users are all anonymous visitors to a web site.
Paul
Are you logging in each user to a unique oracle schemna?
If so, no hope... (other than oracle tuning per Tim's message --
pre-spawned listeners on the da
Perhaps this'll help:
http://perl.apache.org/docs/1.0/guide/performance.html#Persistent_DB_Connections
There's a link on that site to "Tim Bunce's Advanced DBI talk", but it returns a 500.
Tim???
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] QuadT
My CGI application will be called by different users at different
times. Are you saying the first user's connection can be left open
for all the other users? How?
Paul
Most people with experience with Oracle know that opening oracle connections
is SLOW!
Oracle does not appear to consider that a
On Mon, Oct 18, 2004 at 05:09:05PM +0100, Tim Bunce wrote:
> I'd like to get a list of open source perl (DBI based) database
> interface GUIs for unix (Tk/Gtk etc).
I should clarify that a little. Basically I'm intereted in something
that'll open a dialog box asking for connection details, then pr
On Mon, Oct 18, 2004 at 11:48:11AM -0600, Reidy, Ron wrote:
>
> 1. Read the DBD::Oracle docs. There is a section (albeit, dated) that describes
> how one might make connection times faster.
> 2. Read the Net Services Admin Guide
> (http://download-west.oracle.com/docs/cd/B10501_01/network.920
Maybe Oracle does not think it is a problem, but I (and lots of others) would
disagree. These issues are correctable.
In the case of slow logins, it depends on what is being done when the connection is
made. When making connections that are dedicated server (not MTS) a process is
created. If
Steffan,
Try measuring the time it takes to connect with SqlPlus by using
"Time::HiRes" with the variables $time1 and $time2 both set to
gettimeofday() and the the length of time set to $time2-$time1, as
follows:
$time1=gettimeofday();
your code runs here;
$time2=gettimeofday();
print $time2-$t
Most people with experience with Oracle know that opening oracle connections
is SLOW!
Oracle does not appear to consider that a problem, just like they do not
consider slow performance for doing DDL a problem
Applications that require near real time (OLTP) response times open
connections once, an
Hi !
I have this message chen I tape the line :
ppm install DBI.ppd
Error : no suitable installation target
What is the reason of this message. I didn't find anything on the web.
Could you help me please ?
Thanks, Raph
-
Créez gratuite
Success at last! I had the dba create an instance with the database
character set AL32UTF8 (thanks to the excellent documentation with
DBD::Oracle 1.16, which explained the weird behavior of Oracle with plain
UTF8), and used NLS_LANG=.UTF8, and DBD::Oracle 1.16 (1.15 did not work
100%, even with
I'd like to get a list of open source perl (DBI based) database
interface GUIs for unix (Tk/Gtk etc).
If people could send me (off-list) details of any they know
I'll summarize back to the list.
Thank you.
Tim.
On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
>
> >DBD::Oracle::dr::load_dbnames is only called by data_sources()
> >so don't call data_sources() unless you really need to.
>
> I really do need to call data_sources() but the time it takes to
> retrieve data, as shown above, usin
Tim,
It is 3 to 4 times longer than retrieving data from a MySQL database.
Only 3 to 4 times longer than retrieving data from a MySQL?
You're lucky, it's often longer! :)
That was 3 to 4 times longer using the data from "d:DProf".
But it's 20 times longer using "Time::HiRes" to measure the time
On Mon, Oct 18, 2004 at 02:20:14PM +0530, rajarathnam, devaraj wrote:
> Hi
> I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i.
>
> I would like to know the amount of CPU usage by Oraperl since we are having
> CPU usage constraints.
The CPU usage by Oraperl (
Hi
I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i.
I would like to know the amount of CPU usage by Oraperl since we are having
CPU usage constraints.
I would also like to know whether waiting for input will put the state of the
process to 'Slee
Hi
I am using Oraperl emulation for DBD:Oracle for a perl program in HP-UX11i.
I would like to know the amount of CPU usage by Oraperl since we are having
CPU usage constraints.
I would also like to know whether waiting for input will put the state of the
process to 'Slee
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.93.tar.gz
size: 42606 bytes
md5: c3cad1e4b5576895939423f8130da1bb
Changes:
Implemented do().
Changed $sth->DESTROY to call finish( $sth ) instead of $sth->finish.
The old call caused clearing of errors e.g. in $dbh->do().
Replaced
Well, do you know what cause that delay? Between an Oracle client and
Database Server?
- Original Message -
From: "Steffen Goeldner" <[EMAIL PROTECTED]>
To: "Paul Appleby" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 11:34 AM
Subject: Re: Slow connection to
Paul Appleby wrote:
> I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to
> connect to a local Oracle 9i database
[...]
> Why is the connection time so long and how can I shorten it?
[...]
> It takes 2.9342188835144 seconds to connect to the database.
How long does it take with
On Sun, Oct 17, 2004 at 09:06:56PM -0400, Paul Appleby wrote:
> I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a
> local Oracle 9i database table and retrieve the data in the three small fields of
> its only two records.
>
> Why is the connection time so long an
35 matches
Mail list logo