--=__PartCAEC7A31.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Well, actually there is.
Do the processing in a plperlu function which uses it's own connection to
=
the db. Then every instance of the function will have it's own
transaction.=
Try to start that perl connection outside the function or your performance
=
will drop too much.
I use this technique to fetch, process and store records from an oracle db
=
(erp) in a postgresql db (datawarehousing/re****ting/external data).
It gets me some 500,000 records in little over 50 minutes.
Probably real perl addicts would have a lot to say about my coding, but =
being a perl illiterate (does one write it like this?) I must say that I'm
=
quite happy with the result.
All I used was the perl chapter in the postgresql manual (big hurray for =
the manual), perl express for testing and debugging of a lot of very=20
basic things like hashes (yes, illiterate !-) and EMS SQL Manager.
Good luck
>>> "A. Kretschmer" <andreas.kretschmer@[EMAIL PROTECTED]
> 2008-04-07 15:01 =
>>>
am Mon, dem 07.04.2008, um 14:46:50 +0200 mailte luke.78@[EMAIL PROTECTED]
=
folgendes:
> Hi,
> I have to execute commit for evey record that i processed during a =
cursor fetch in a function.
> There is a way to do it?
No.
Regards, Andreas
--=20
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
( =
http://wwwkeys.de.pgp.net/
)
--=20
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--=__PartCAEC7A31.0__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Well, actually there is.</DIV>
<DIV>Do the processing in a plperlu function which uses it's own
connection=
to the db. Then every instance of the function will have it's own =
transaction.</DIV>
<DIV>Try to start that perl connection outside the function or your =
performance will drop too much.</DIV>
<DIV>I use this technique to fetch, process and store records from an
=
oracle db (erp) in a postgresql db
(datawarehousing/re****ting/external=
data).</DIV>
<DIV>It gets me some 500,000 records in little over 50 minutes.</DIV>
<DIV>Probably real perl addicts would have a lot to say about my coding, =
but being a perl illiterate (does one write it like this?) I =
must say that I'm quite happy with the result.</DIV>
<DIV>All I used was the perl chapter in the postgresql manual (big hurray
=
for the manual), perl express for testing and debugging of a lot of very =
</DIV>
<DIV>basic things like hashes (yes, illiterate !-) and EMS SQL
Manager.</DI=
V>
<DIV>Good luck<BR><BR>>>> "A. Kretschmer"
<andreas.kretschmer@[EMAIL PROTECTED]
2008-04-07 15:01 >>><BR>am Mon, dem =
07.04.2008, um 14:46:50 +0200 mailte luke.78@[EMAIL PROTECTED]
folgendes:<BR>>
=
Hi,<BR>> I have to execute commit for evey record that i processed =
during a cursor fetch in a function.<BR>> There is a way to do =
it?<BR><BR>No.<BR><BR><BR>Regards, Andreas<BR>-- <BR>Andreas
Kretschmer<BR>=
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr:
=
-> Header)<BR>GnuPG-ID: 0x3FFF606C, privat
0x7F4584DA &=
nbsp; <A
href=3D"http://wwwkeys.de.pgp.net/">http://wwwkeys.de.pgp.net</A><=
BR><BR>-- <BR>Sent via pgsql-sql mailing list
(pgsql-sql@[EMAIL PROTECTED]
)<BR=
>To make changes to your subscription:<BR><A
href=3D"http://www.postgresql.=
org/mailpref/pgsql">http://www.postgresql.org/mailpref/pgsql</A>-sql<BR></D=
IV></BODY></HTML>
--=__PartCAEC7A31.0__=--
|
