From: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | General question about DBI/DBD |
Date: | 2001-11-09 16:02:44 |
Message-ID: | 20011109110244.A25375@allhats.xcski.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've got a very big program that I wrote using Pg.pm, and now I'd like to
convert it to using DBD:Pg. Can anybody give me any general tips on how
to do that? Just convert all the $conn->exec to $DBH->do, or is it more
complicated than that?
Also, the big program does a whole bunch of
$conn->exec("SELECT * FROM tablename WHERE indexed_column = '$key'");
and things like that. Is there a way in DBD:Pg I can re-parse those
queries with "...indexed_column = :1" and then supply a different key each
time? I remember when I used to write C programs that accessed Oracle
(about 8 years ago, so the details are hazy), that was a major performance
improvement.
--
Paul Tomblin <ptomblin(at)xcski(dot)com>, not speaking for anybody
"I had to kill him -- he was starting to make sense."
From | Date | Subject | |
---|---|---|---|
Next Message | qradius | 2001-11-09 16:21:57 | How to view the functions that exists |
Previous Message | Francisco Reyes | 2001-11-09 15:53:06 | Re: Disable Transaction - plans ? |