Received: from mail1.teleport.com (mail1.teleport.com [192.108.254.26]) by hub.org (8.9.2/8.9.1) with SMTP id SAA56767 for ; Sun, 21 Feb 1999 18:02:18 -0500 (EST) (envelope-from gregg@gbcomputers.com) Received: (qmail 11076 invoked from network); 21 Feb 1999 23:02:16 -0000 Received: from i48-20-37.pdx.du.teleport.com (HELO gbcomputers.com) (216.26.6.229) by mail1.teleport.com with SMTP; 21 Feb 1999 23:02:16 -0000 Message-ID: <36D09076.A762A525@gbcomputers.com> Date: Sun, 21 Feb 1999 15:02:15 -0800 From: Gregg Berkholtz Organization: GB Computers X-Mailer: Mozilla 4.5 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 To: PostgreSQL SQL Listserv Subject: SQL query _slow_ 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; Thanks for any help! Gregg Berkholtz