Re: DBI ODBC select statement length

2007-08-31 Thread Paul Appleby
to find some direction, but have come up empty. Has anybody seen this before? Or is this something obvious and I should be hit with a rolled up news paper for not figuring it out? Thanks. -Brian -- Christopher Sarnowski [EMAIL PROTECTED] Penn Bioinformatics Core 1316 Blockley Hall MC 6

DBD::mysqlPP.pm and Timeout of authentication error

2007-08-02 Thread Paul Appleby
e 109. Has anyone else encountered this issue? Has anyone found the reason for the error and resolved it? Any help would be appreciated. -- Sincerely, Paul Appleby

Re: Are there error or Status Codes???

2004-11-06 Thread Paul Appleby
kMail.com - Spam-Zapper.com - SPAM Stops Here. President of the Pittsburgh InfraGard Alliance -- Sincerely, Paul Appleby (416) 530-0070 http://www.paulappleby.com http://myspider.ca

Re: Slow connection to Oracle 9i

2004-10-21 Thread Paul Appleby
mailing list on the site, that he mentions below. You can find many other Oracle lists by searching for on . But all of you probably knew that. Thanks. Paul It's time to end this thread now - or take it to an Oracle specific mailing list like oracle-l. Thanks. Tim. -- Sincerely, Paul Appleby

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
you saying the first visitor to the web site's connection can be left open for all the other visitors? How? Perhaps, though you understand it as such without this clarification. Paul On Mon, Oct 18, 2004 at 04:39:25PM -0400, Paul Appleby wrote: > My CGI application will be called by d

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
particular table in a particular schema for a particular user? Paul 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?

RE: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
n the database can make a BIG difference ... talk to your dba's) Lincoln -Original Message----- From: Paul Appleby [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 4:39 PM To: BAXTER, LINCOLN A Cc: [EMAIL PROTECTED] Subject: RE: Slow connection to Oracle 9i My CGI application will

RE: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
, for instance, Websphere caches pooled connections in the java world. Lincoln -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 12:06 PM To: Paul Appleby Cc: [EMAIL PROTECTED] Subject: Re: Slow connection to Oracle 9i On Mon, Oct 18, 2004 at 10:38

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
int $time2-$time1; Paul 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 do

Re: Slow connection to Oracle 9i

2004-10-18 Thread Paul Appleby
l 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, using "Time::HiRes" is only 0.0100140571594238 seconds. So that's not the issue. -- Sincerely, Paul Appleby

Slow connection to Oracle 9i

2004-10-17 Thread Paul Appleby
port 0.00 0.000 -0.000 4 0. - warnings::register::mkMask Sincerely, Paul Appleby