SQL query _slow_
От
Gregg Berkholtz
Тема
SQL query _slow_
Дата
Msg-id
36D09076.A762A525@gbcomputers.com
Список
Дерево обсуждения
Re: [SQL] SQL query _slow_ Gregg Berkholtz <gregg@gbcomputers.com>
Re: [SQL] SQL query _slow_ Bruce Momjian <maillist@candle.pha.pa.us>
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
В списке pgsql-sql по дате отправления