Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id SAA60818 for ; Sun, 21 Feb 1999 18:54:17 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id SAA01581; Sun, 21 Feb 1999 18:52:21 -0500 (EST) From: Bruce Momjian Message-Id: <199902212352.SAA01581@candle.pha.pa.us> Subject: Re: [SQL] SQL query _slow_ In-Reply-To: <36D09076.A762A525@gbcomputers.com> from Gregg Berkholtz at "Feb 21, 1999 3: 2:15 pm" To: gregg@gbcomputers.com (Gregg Berkholtz) Date: Sun, 21 Feb 1999 18:52:21 -0500 (EST) Cc: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > I have a few SQL query's that are taking in the range of 30-60 seconds > to complete. They are searching tables that are no larger than 120 rows > with I believe 7 columns of data each. > Any ideas? > The SQL statement is below: > > SELECT tblClientInfo.fName, tblClientInfo.lName, tblClientInfo.phoneNum, > tblClientLocation.locationName, tblTroubTick.TroubTickLastUpdate, > tblTroubTick.hoursInvested, tblSupportPersInfo.fName, > tblSupportPersInfo.lName, tblPriority.priority, tblTroubTick.assetID, > tblTroubTickStatus.troubTickStatus, tblTroubTickProblem.troubTickProblem > > FROM tblClientInfo, tblTroubTick, tblClientLocation, tblSupportPersInfo, > tblPriority, tblTroubTickStatus, tblTroubTickProblem > WHERE tblTroubTick.troubTickStatusID <> 7 AND > tblClientLocation.locationID = tblClientInfo.locationID AND > tblTroubTick.clientID = tblClientInfo.clientID AND > tblTroubTick.supportPersID = tblSupportPersInfo.supportPersID AND > tblTroubTick.priorityID = tblPriority.priorityID AND > tblTroubTick.troubTickStatusID = tblTroubTickStatus.troubTickStatusID > AND tblTroubTick.troubTickProblemID = > tblTroubTickProblem.troubTickProblemID; 6.5 will have a majorly improved optimizer. We hope to start beta in a month. Hope you can wait. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026