From: | Guy Rouillier <guyr-ml1(at)burntmail(dot)com> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Writing most code in Stored Procedures |
Date: | 2007-08-17 22:26:08 |
Message-ID: | 46C62080.6050305@burntmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Steve Manes wrote:
> I'm fairly hardcore about keeping as much business logic as I can in the
> database. In fact, I only do SELECTs from the application, and usually
> via Views. All inserts, updates and deletes are via procs.
...
> And, yes, it's faster. Particularly if business logic decisions have to
> be made in context with a transaction.
I have a thread I started ages ago over on the PERFORM list that I'm
sadly just now being able to provide some insight on. I'll be replying
on that thread in more detail, but the short of it turns out to be that
at least in this one application, using stored procs for inserts is
slowing down the app considerably. The app does high volume inserts and
updates, about 16 million rows a day. By switching from stored procs to
inline inserts, elapsed time dropped from 2595 seconds to 991 seconds
for a test run.
So the moral of the story is that, as anyone who has worked
professionally for a number of years knows, no magic bullets exist.
General guidelines can be helpful, but each scenario must be
individually investigated.
--
Guy Rouillier
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-08-17 22:31:15 | Re: I get a error msg when i try to connect to the DB |
Previous Message | Lars Ellenberg | 2007-08-17 19:34:55 | Re: PostgreSQL clustering (shared disk) |