Re: Performance: Perl-DBI vs. PG Stored Procedures
От | Alex Avriette |
---|---|
Тема | Re: Performance: Perl-DBI vs. PG Stored Procedures |
Дата | |
Msg-id | 32BAF2A2B169D411A081009027464529025DB397@ATD-NT5 обсуждение исходный текст |
Ответ на | Performance: Perl-DBI vs. PG Stored Procedures (David Link <dlink@soundscan.com>) |
Список | pgsql-general |
Yes. The PL/SQL programs will be faster since theyre stored in postgres. Doing things like nested selects, however, will be faster in perl with arrays/hashes than they would be in sql. you might also consider dropping any indexes you have before inserting and then re-creating them. this is provided, of course, you only have one concurrent user. alex -----Original Message----- From: David Link [mailto:dlink@soundscan.com] Sent: Tuesday, November 20, 2001 11:10 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Performance: Perl-DBI vs. PG Stored Procedures Hi, Could there be performance gains by using PG stored procedures rather than using generic Perl DBI programs? Namely for a task that loops thru a cursor of several 50,000 rows and does UPDATES or INSERTS back into that same table. It is takes hours. Thanks, David ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления: