| From: | Chantal Ackermann <chantal(dot)ackermann(at)web(dot)de> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Subject: | Temporary table instead of repeated joins | 
| Date: | 2002-07-02 12:48:50 | 
| Message-ID: | 3D21A132.4070608@web.de | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
hello all,
in my program I have to check for a certain combination of data before I 
make an insert. The check is a select statement with a join and a 
function call. Now, I wonder if I could gain performance if I would 
create a temporary view that contained this join and the function call 
and the other constraints. There will be frequent inserts into the 
underlying tables so I can't use a real cache that is only updated once 
in a while (say, a temporary table).
So would a select on the view be faster or is the view really just some 
shortcut for the programmer but the database behaviour actually stays 
the same?
Thanks for any hints
Chantal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2002-07-02 13:57:09 | Re: CASE Select, referring to selected value | 
| Previous Message | Achilleus Mantzios | 2002-07-02 12:16:53 | Re: CASE Select, referring to selected value |