Re: Trouble converting SQL from Access

[Leo G. Divingracia III]

Asendorf, John wrote:
.

SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS
Distance
FROM Dealers INNER JOIN Zips ON Dealers.Zip = Zips.Zip
ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2)

Any suggestions to speed this guy up?

yeah, do you really need ALL the columns returned?

also, if you can, offload the calculations to PHP*, like the POW() function...


grab the data from MYSQL and then use PHP to do the calcs...*


--
Leo G. Divinagracia III
[EMAIL PROTECTED]

zzzzz


---------------------------------------------------------------------
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