Thank you very much! I am a first year software engineer so I'm still
learning :-)
I had a query that took 23 seconds, and now takes .01 sec.
Thanks again!
Rob Taft
-
Before posting, please check:
I have 2 tables, one with 1,000 entries, the other with 10,000 entries. I'll
call these table1 and table2. The query uses both tables:
SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID =
table2.table1_ID) WHERE some condition;
table2.table1_ID is just an int that matches an
an explain on
your query to make sure it is utilizing indexes.
-Original Message-
From: Rob Taft [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 10:53 AM
To: [EMAIL PROTECTED]
Subject: LEFT JOIN function locking up when using large
database
I have 2 tables, one with 1,000 entries
]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 7:53 PM
Subject: LEFT JOIN function locking up when using large database
I have 2 tables, one with 1,000 entries, the other with 10,000
entries. I'll
call these table1 and table2. The query uses both tables:
SELECT something to select FROM
Rob Taft wrote:
I have 2 tables, one with 1,000 entries, the other with 10,000 entries. I'll
call these table1 and table2. The query uses both tables:
SELECT something to select FROM table1 LEFT JOIN table2 ON (table1.ID =
table2.table1_ID) WHERE some condition;
Do you have indexes on