Thread

RE: [GENERAL] Speed

Jackson, DeJuan <djackson@cpsgroup.com> — 1999-04-27T19:18:31Z

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
>