Re: [PHP-DB] Optimize following Mysql-Query

2003-05-31 Thread Paul Burney
on 05/30/2003 7:49 AM, André Sannerholt at [EMAIL PROTECTED] appended the following bits to my mbox: 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? Since subselects are fairly new to MySQL and

RE: [PHP-DB] Optimize following Mysql-Query

2003-05-31 Thread Vaughn, Paul
Title: RE: [PHP-DB] Optimize following Mysql-Query Another large performance hit is the use of like with the wildcards. If you can avoid wildcard searches do. WHERE Personen.NAME IN ('$name'); or = $name Obviously this is only valid if the variable is going to match what is in the data

[PHP-DB] Optimize following Mysql-Query

2003-05-30 Thread André Sannerholt
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