From: | "Koen Antonissen" <koen(at)v3(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Join performance |
Date: | 2000-12-05 09:42:09 |
Message-ID: | BBEPKLBOJENIHNEGNKLFGEMMCBAA.koen@v3.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi there,
I'm having some problems with the performance on queries including a join.
for example:
SELECT members_data.pwd FROM emails,members_data WHERE emails.email =
'koen(at)v3(dot)com' AND emails.uin = members_data.uin;
is a lot slower then extracting the join into 2 seperate queries like:
SELECT emails.uin FROM emails WHERE lower(emails.email) = 'koen(at)v3(dot)com';
--and use the result in the next query ($db_result)
SELECT members_data.pwd FROM members_data WHERE members_data.uin =
$db_result;
Now the login routine is MUCH faster ;-) , but performance problems remain
when the the result is more than 1 record (Unlike a unique emailaddress...)
Is there anyone out there who has ideas how to write faster queries
including tablejoins?
I already tried Inner Join, Natural Join and Join On, wich didn't seem
affect the performance in any way...
Kind regards,
Koen Antonissen
koen(at)trilab(dot)com
www.trilab.com
From | Date | Subject | |
---|---|---|---|
Next Message | Clayton Cottingham | 2000-12-05 09:58:41 | Re: how to execute a C program via trigger ? |
Previous Message | S.F. Lee | 2000-12-05 02:20:29 | Re: how to execute a C program via trigger ? |