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
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 seconds when there
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 50,000
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 that
