RE: Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?

Sorry for the long reply: At 02:57 PM 6/10/2002 -0500, you wrote: >[snip] >SELECT > head.po >FROM > head > LEFT JOIN line ON (head.sn=line.snHead) >WHERE > head.po > 1 > AND line.dateETA<='2002-06-10' >LIMIT 50 > >As is, this query is very fast (0.01 second

Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?

Hi List, I sure do appreciate this list. I'm stumped on the following query: SELECT head.po FROM head LEFT JOIN line ON (head.sn=line.snHead) WHERE head.po > 1 AND line.dateETA<='2002-06-10' LIMIT 50 As is, this query is very fast (0.01 seconds when the

Re: Thread based optimization?

Hi All At 11:17 PM 6/6/2002 -0700, Jeremy wrote: > > However, there is the occasional "select" query that requires a good > > amount of work on the database. > >Why? Can it be optimized? The query is needs about 10 left joins, and requires data from about 12 different tables (some tables have

Thread based optimization?

Dear list, After doing a good bit of reading, the details are still hazy. I have a web-based application (about 20 tables, with up to 100,000 records per table - but most tables are much smaller). 99% of "select" queries are very very fast. However, there is the occasional "select" query tha