What database are you using?
Also, are all the fields involved in the joins and whare clause
properly indexed? Depending on the database you are using, it is possible
to determine if the indexed fields are being used.
On Tue, 3 Jun 2003, André Sannerholt wrote:
> Hi everybody,
> now I have the following qery that still needs to much time:
> select distinct Anschriften.ID as aid, Anschriften.PLZ as aplz,
> Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from Anschriften
> inner join Master on Anschriften.ID=Master.A
> inner join Master as m on Master.FN=m.FN
> inner join Personen on m.NN=Personen.ID
> where Personen.ID = "$id"
> It gives me the correct results
> I hope you can help me to get it faster!
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php