You use LEFT JOIN so your query is optimized. Probably your tables are big, you don't 
have many MB of RAM. When you have big RAM, I
think that tables reside in memory and join of 5 tables every >600,000 rows is done 
for 4-5s. May be you have to increase some of
the buffers sizes of mysql.

Regards,
Andrey Hristov
----- Original Message -----
From: "Martin E. Koss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 12:09 PM
Subject: [PHP-DB] JOIN Very SLOW...


> The following does work but it extremely slow.
>
> $phselect = "select COUNT(*) AS phTotal from properties LEFT JOIN
> propertydetails ON properties.PropertyID=propertydetails.PropertyID where
> ((propertydetails.Image1Desc='') AND
> (properties.PropertyType='$PropertyType'))";
>
> $phresult = mysql_query ($phselect,$conID);
> while ($phrow = mysql_fetch_array($phresult)) {
> $phTotal = $phrow["phTotal"];
> PRINT "<td align=\"right\">$phTotal</td>\n";
> } // end WHILE
>
> Is there an obvious problem here and can anyone help?
>
> Martin E. Koss
> M: 07946-706459
> E: [EMAIL PROTECTED]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to