From: | Gregg Berkholtz <gregg(at)gbcomputers(dot)com> |
---|---|
To: | PostgreSQL SQL Listserv <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | SQL query _slow_ |
Date: | 1999-02-21 23:02:15 |
Message-ID: | 36D09076.A762A525@gbcomputers.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-21 23:52:21 | Re: [SQL] SQL query _slow_ |
Previous Message | George Henry C. Daswani | 1999-02-21 22:33:09 | HAVING confusion.. |