Guilherme,
Thursday, July 25, 2002, 4:18:13 AM, you wrote:
G> I have 3 tables tableA, tableB and tableC and the fields tableA.id,
G> tableB.idA and tableC.idA.
G> I'm using this query (bellow) to call information from the database that has
G> in tableA but tableA.id is not found on tableB.idA and tableC.idA.
G> SELECT tableA.*
G> FROM tableA
G> LEFT JOIN tableB ON (tableB.idA = tableA.id)
G> LEFT JOIN tableC ON (tableC.idA = tableA.id)
G> WHERE tableB.idA IS NULL AND tableC.idA IS NULL;
G> With a low ammount of data (30 records) I receive the data really fast.
G> However with a greater ammount of data (1800 records) it takes 26 seconds to
G> return data and it consumes 100% of processor. This situation happens when I
G> have all tableA.id registered on tableB.ida or tableC.ida.
G> Any ideas?
You gave incomplete info. What is the structure of your tables? Show
the output of EXPLAIN SELECT:
http://www.mysql.com/doc/E/X/EXPLAIN.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php