Russ wrote: > No, I'm referring to: > > http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:50203#268818 >
That one is pretty quick here... SELECT b.* FROM tblzipcodes a CROSS JOIN tmpzipcodes b WHERE dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude) < 10 AND a.zip = '27614' Took 1412 ms. I limited the latitude side of things with... SELECT b.* FROM tmpzipcodes a CROSS JOIN tmpzipcodes b WHERE a.zip = '27614' AND b.latitude < a.latitude + (10*.014457) AND b.latitude > a.latitude - (10*.014457) AND dbo.getDistance(a.latitude,a.longitude,b.latitude,b.longitude) < 10 which only took 170ms I think that .014457 is right...basically 1 degree/69.172 miles. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4