On 11-Jul-2006 Jimmy Li wrote:
> Can I end a transaction as soon as I call execute()?
Yes
> or do I have to wait
> until I finish fetching all the rows?
No
> For example, I have:
>
> --
> -
Tim,
I'm experiencing further memory leaks which are causing me more grief. I put
together the following test script which illustrates the leakage:
#/usr/bin/perl
# dbi.pl
use DBI;
use Devel::Leak;
my $leak_handle;
for ( 1 .. 1000 ) {
my $dbh = DBI->connect("DBI:mysql:MYDB","user","secret"
Hello List!
I've got quite some trouble installing DBD:mysqli (3.0006) on a Debian box
running MySQL 5.0.22. It would be great if some of you had some idea on how
to solve this.
So here's what happens when I try doe build the package:
--
You're overriding the cflags, so none of the mysql include directories are
present. Try leaving off the --cflags argument, so that mysql_config can
supply the cflags...
> -Original Message-
> From: Whisky [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 11, 2006 14:18
> To: 'mailing list
Thank you very much, Ephraim. That helped!
Now I've got a new problem. DBD:mysql compiles but make test fails. Maybe
you have an idea on this one, too.
Once again, here's the complete output:
SERVER:/usr/src/perl/DBD-mysql
You're not linking in some libraries, or your runtime LD path is not right, but
I couldn't tell you why.
A quick google showed me:
http://archive.gingerall.cz/archives/public/sablot2003/msg00537.html
Which looks reasonably relevant.
You could try something like:
perl Makefile.PL
--mysql_config=
I'm sorry but I simply don't have the time at the moment.
Some random suggestions:
- try using different sets of methods to isolate the minimum requirements.
for example:
call fetchrow_array just once.
don't call fetchrow_array at all.
call fetchrow_array in loop but do
On 7/11/06, Martin J. Evans <[EMAIL PROTECTED]> wrote:
On 11-Jul-2006 Jimmy Li wrote:
> Can I end a transaction as soon as I call execute()?
Yes
Depends on the statement, of course, and the AutoCommit mode. For something
other than a cursor-based statement (fetch, or sometimes some version
From looking around with Google, it would APPEAR that you can
implement a cursor WITH UPDATE in DBI, but I have not been able to
find an example of that. Would anyone happen to have a bare-bones
code framework for such a thing?
Since I should give an example of the kind of operation I hope to d
$sth->{CursorName} is a key part of it.
See also the docs for DBD::Informix (http://search.cpan.org/) for an example
- the POD has a section CURSORS FOR UPDATE that shows how to do it.
On 7/11/06, pDale <[EMAIL PROTECTED]> wrote:
From looking around with Google, it would APPEAR that you can
im
Jonathan,
You are of course right.
I read the word transaction but saw the select and missed the do
to begin a transaction. My comments were based on a simple select
outside a transaction.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
On Tue, 2006-07-11 at 09:18 -0700, Jona
On 7/11/06, Jonathan Leffler <[EMAIL PROTECTED]> wrote:
On 7/11/06, pDale <[EMAIL PROTECTED]> wrote:
> From looking around with Google, it would APPEAR that you can
> implement a cursor WITH UPDATE in DBI, but I have not been able to
> find an example of that. Would anyone happen to have a bare
Thanks for your ideas, Ephraim.
Although the article you mentioned didn't apply to the problem I finally
found a solution. I just used the sources of MySQL 5.0.18 and now everything
works fine. Maybe the command line I used is of some help for other people
searching the archives...
perl Makefile.
13 matches
Mail list logo