From: Gregg Berkholtz <gregg@gbcomputers.com>
To: PostgreSQL SQL Listserv <pgsql-sql@postgreSQL.org>
Subject: SQL query _slow_
Date: Sun, 21 Feb 1999 15:02:15 -0800
Message-ID: <36D09076.A762A525@gbcomputers.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: gregg@gbcomputers.com
Subject: Re: SQL query _slow_
In-Reply-To: <36D09076.A762A525@gbcomputers.com>
References: <36D09076.A762A525@gbcomputers.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox