> -----Original Message-----
> From: Jason Tesser [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 12, 2004 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] help with query speed
>
>
> I have the below query written. I have removed a lot from the select
> Statement for simplicity sake. The query takes way too long.
> I am moving from an Access backend to a Postgres back with
> Access in the front. The below query is taking like 14-20 seconds.
> Is their a better way I can write the joins. I would think that
> Postgres should be fast than Access. BTW I am writing these as
> Pass through queries so it is not a problem with Access. I
> have Even ran the query directly against Postgres.
>
> SELECT
> tblroster.transcriptlink
> FROM
> tblroster
> FULL OUTER JOIN testclass ON (tblroster.classlink =
> testclass.classid)
> FULL OUTER JOIN tblqualitypoint ON (tblroster.lettergrade =
> tblqualitypoint.letter)
> ORDER BY
> tblroster.transcriptlink
Is there an index on:
tblroster.classlink
Is there an index on:
testclass.classid
Is there an index on:
tblroster.lettergrade
Is there an index on:
tblqualitypoint.letter
Is there an index on:
tblroster.transcriptlink
How many rows are in the tables?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
