Hello,
I'm having troubles to get working the script fti.pl shipped with
fulltextindex plugin for postgres 7.3.2:
Undefined subroutine &main::PQconnectdb called at
/usr/local/postgres-7.3.2/bin/fti.pl line 103, line 2
the script consists the line: "use Pg;"
In your mailing list I learned th
- Original Message -
From: "Alex Pilosov" <[EMAIL PROTECTED]>
To: "Michael Wray" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 14, 2001 10:51 AM
Subject: Re: Perl Pg Vs. DBD::Pg
> Using DBI, you must be careful how you
Using DBI, you must be careful how you fetch the data.
There are methods for fetching entire result set as an array of arrays or
array of hashes, but doing row-by-row fetching as a reference of an array
is fastest. That was most likely the reason for disparity.
-alex
On Tue, 13 Nov 2001, Mic
Hmm...well I don't have the DBD code I used but basically it was something like:
$dbh->Autocommit=0
$dbh->do (qw($query));
$dbh->commit
disconnect...
(I'd have to verify my syntax against Programming the Perl DBI and the DBD::Pg
manpage.)
(Pretty straight forward..and is what I am doing with Pg
I think you are doing something wrong. DBD::Pg is fast-to-unnoticeable.
I bet that with PHP you do your operations within one transaction (do an
explicit BEGIN or whatever way in PHP you start a transaction), whereas in
perl, you don't do $dbh->{AutoCommit}=0;
The best way to kill postgres' perf
Thanks for the suggestions, but here's my 2 cents on DBI/DBD::Pg:.
I would LOVE to use DBD::Pg...I have written a lot of code using
DBD::Pg...however...unless there is a Monumental Performance increase between DBD::Pg
that was out with DBI-1.16, and the current version..I don't think I can con
On Mon, 12 Nov 2001, Rudy Lippan wrote:
> There is(was?) a "Pg" interface to perl:
> http://search.cpan.org/doc/MERGL/pgsql_perl5-1.9.0/Pg.pm
Yes, it's basically just a wrapper for libpq and basically has the same
set of functions/methods.
-- Brett
http
On Mon, 12 Nov 2001, Hardy Merrill wrote:
> By "Pg", do you mean PostgreSQL database? The only interface that
> I'm aware of for Perl to PostgreSQL is through DBI and DBD::Pg. In
> terms of documentation for PostgreSQL, I'd start with the Postgresql
> home page at
There is(was?) a "Pg" interfa
.com) and search for "postgresql".
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Michael Wray [[EMAIL PROTECTED]] wrote:
> I know this is off-topic..but I am just looking for a place with good documentation
>for Perl-Pg. Since for my pu
I know this is off-topic..but I am just looking for a place with good documentation
for Perl-Pg. Since for my purposes performance is key and the Pg module can give it
to me..but the documentation for it is poor at best, and I am not a C-programmer and
am an amateur at Perl at best so I need
10 matches
Mail list logo
