Excellent!
By changing the order of the tables being joined I reduced the execution
time from 2800ms to 20ms!
Very useful command.
Thanks very much!
At 14:20 29/06/2001 -0300, you wrote:
>Are the fields been JOINed indexed? If not, they should.
>
>Have you tried an EXPLAIN command? Try it like EXPLAIN SELECT DISTINCT ....
>(and the rest of your query) It will bring a table stating what indexes are
>been chosen by MySQL to perform the query. It is worth trying to play with
>it until you get a faster join between tables.
>
>Hope it helps,
>
> >From a british-hearted chap from Brazil. :-)
>
>Tiago Luchini
>Diretor Técnico-Comercial
>Galluch Soluções Internet
>Telefax: 11 6912 3255
>Celular: 11 3176 7740
>http://www.galluch.com.br/
Dean Ware
Web Developer
http://www.readingroom.com
Winner : Best Business to Business Website 2000-01
(Internet Business Awards sponsored by ntl)
Reading Room Ltd.
77 Dean Street
Soho
London
W1D 3SH
UK
Tel: +44 (0) 20 7734 9499
Fax: +44 (0) 20 7439 4190
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, re-transmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.
---------------------------------------------------------------------
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
