Optimize following Mysql-Query
| From: | Andr� Sannerholt | Date: | Fri, 30 May 2003 11:49:14 +0000 |
| Subject: | Optimize following Mysql-Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28159@lists.php.net to get a copy of this message | ||
Hi Everyone,
I have the following Mysql-Query that returns correct information, but it
just needs to much time (3-4 Minutes!!) Can you help me to optimize it?
$query=
"SELECT * FROM Firmennamen INNER JOIN Master ON Firmennamen.ID=Master.FN
WHERE Master.FN IN (SELECT Master.FN FROM Master INNER JOIN Personen ON
Master.NN=Personen.ID WHERE Personen.NAME LIKE '%$name%')";
$result = mysql_query($abfrage2) or die("Anfrage results fehlgeschlagen");
Regards
André Sannerholt