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:
http://www.mysql.com/manua
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 FROM table1 LEFT JOIN table2 ON (table1.ID =
table2.table1_ID) WHERE ;
Do you have indexes on these?
alter table2 add index table1_i
ED]>
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:
>
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, the
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 FROM table1 LEFT JOIN table2 ON (table1.ID =
table2.table1_ID) WHERE ;
table2.table1_ID is just an int that matches an ID from table1. This way I
can get
