Use Indexes...
-DEJ
> -----Original Message-----
> From: Justin Long [SMTP:justinlong@strategicnetwork.org]
> Sent: Tuesday, April 27, 1999 11:31 AM
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] Speed
>
> I find that it is actually faster to do a SELECT from a single record set,
> then fetch each individual row and do additional SELECTS to find
> additional
> pieces of data from other databases, rather than to a join between two or
> three databases
>
> for example
>
> SELECT ctryid, dirid, notes from initiative order by postedon limit
> 3;
> (for each individual record in the above select)...
> select name from country where country.ctryid=iRec.ctryid
> select name from directory where directory.dirid=iRec.dirid
>
> (well this is kind of abstract code but you can follow the logic)
>
> Has anyone else noticed that when you do multiple joins the speed of
> PGSQL6.5 goes down dramatically? This is the difference between 2 seconds
> for the above and 15 for a join... Is there some way to optimize?
>
>
> Never retreat. Never surrender. Never cut a deal with a dragon.
> _______________________________________________________________
> Justin Long CIO / Site Editor
> 616 Station Square Ct Network for Strategic Missions
> Chesapeake, VA 23320 977 Centerville Trnpk CSB 317
> JustinLong@xc.org Va Beach, VA 23463
> Check out our site at: http://www.strategicnetwork.org
>
