ell/better some other way?
I'm pretty happy with the way it is now. It's pretty simple and easy
to use. I remember with earlier versions it was pretty rough, but a
couple of years ago changes were made that made it much simpler.
* Philip Molter
* Data Foundry
* http://www.datafoundry.com/
* [EMAIL PROTECTED]
On Thu, Mar 06, 2003 at 06:20:07PM +, Tim Bunce wrote:
: On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
: > I have a very long running Perl process. I recently upgraded the
: > DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
: > memory.
On Thu, Mar 06, 2003 at 06:20:07PM +, Tim Bunce wrote:
: On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
: > I have a very long running Perl process. I recently upgraded the
: > DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
: > memory.
s being used in a wrapper,
non-subclassing module) or if this is a C issue.
Philip
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
them.
Anyone know if 1.13 is too old to do this?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
directory and
: reinstall, or edit the installed copy.
:
: Can everyone else who's had a "Can't call method prepare" problem
: with DBI 1.29 please try this.
Aside from the trace core, that patch fixed the problem I was having
with selectrow_array on the upgraded DBI.
* Phili
_pp_entersub ()
#10 0x6cfdc in Perl_runops_standard ()
#11 0x2433c in S_run_body ()
#12 0x23fb0 in perl_run ()
#13 0x213bc in main ()
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
On Tue, Jul 16, 2002 at 04:40:05PM -0500, Philip Molter wrote:
: Well, when I run the code with trace(9), it causes the script (it's
: a web script running under mod_perl) to fail with not even a warning
: to the error log, so I doubt this will be helpful, but here's the
: out
aris/DBI.pm line 1239 via
/usr/home/philip/cvs/web/intranet/cgi-bin//query.pl line 1986
<- selectall_arrayref= [ ARRAY(0xff73f8) ] at
/usr/home/philip/cvs/web/intranet/cgi-bin//query.pl line 1986 via
/usr/home/philip/cvs/web/intranet/cgi-bin//query.pl line 175
-> DESTRO
On Tue, Jul 16, 2002 at 10:26:23PM +0100, Tim Bunce wrote:
: On Tue, Jul 16, 2002 at 03:36:52PM -0500, Philip Molter wrote:
: > I'm not sure exactly where the problems lie, but the symptoms are
: > that when I try to use methods like selectrow_array() and
: > selectrow_arrayref(),
at all why this is happening?
Philip
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
w, but maybe with other reports, this can
be sorted out.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
=' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -ldl -lm -lc -lcrypt -lutil
perllibs=-lnsl -ldl -lm -lc -lcrypt -lutil
libc=/lib/libc-2.2.4.so, so=so, useshrplib=true, libperl=libperl.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun
ement handles cycled in 3.6 cpu+sys seconds (2754 per sec)
test.pl done
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
red with no warranty whatsoever that it will
: work.
That's tested and doesn't work. The whole point of Apache::DBI is
that it intercepts calls to DBI's connect() method and caches them.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
Apache::DBI?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
same holds true for other DBDs.
Use begin_work() or set AutoCommit=1 on your handles and then turn
AutoCommit off for your transactions.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
1.01]# set
:
: POSTGRES_INCLUDE=/usr/local/pgsql/include
: POSTGRES_LIB=/usr/local/pgsql/lib/libpq.so
I think you specify the library directory, not the library itself.
POSTGRES_LIB=/usr/local/pgsql/lib
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
that PostgreSQL has over
MySQL except for very advanced, mostly proprietary extensions (with
the exception of triggers, which are coming). In everything I've
coded, MySQL beats PostgreSQL hands-down for speed when both are
configured properly.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
On Fri, Jan 04, 2002 at 04:40:09PM +, Tim Bunce wrote:
: On Fri, Jan 04, 2002 at 08:21:22AM -0600, Philip Molter wrote:
: > On Thu, Jan 03, 2002 at 01:25:03AM +, Tim Bunce wrote:
: >
: > : Simply calling $dbh = MyDBI->connect(...) will be interpreted
: > : as a requ
ses, something which isn't impossible now, but is a little
annoying.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
pened with RaiseError and Autocommit=0:
We run MySQL-InnoDB in the same type of environment. We've found
that a better way is to only turn AutoCommit off when you need it
turned off (using $dbh->{'AutoCommit'} = 0|1). That way, you don't
have to issue the initial commit().
ike (post an example)? I
would think that if the DBI had a massive memory leak (30MB), there
would be many more complaints. My guess would be either a bad
driver or somehow, that returned hashref is being used in such a
way that it isn't garbage collection (stuck in an array, put in an
It'd be nice to have
the benefits of Apache::DBI with full subclassing of the DBI::db
and DBI::st classes.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
, it seems.
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
am(3, $value, {TYPE => SQL_VARCHAR} );
:
: It works, but ... I shouldn't have to do that.
:
: It's not clear to me what's going wrong here. Has anyone experienced
: something similar, or have any insight into what's happening here?
Right, in this case, you tell the query the
OY code:
sub DESTROY {
my ( $this ) = @_;
# it'll die here, with the error given above
return unless $this && exists $this->{'private_PK_DB_AREA'};
$counts{$this->{'private_PK_DB_AREA'}} = 1;
$keepopen{$this->{'private_PK_DB_A
27 matches
Mail list logo