Welcome Guest, Not a member yet? Register   Sign In
SQL [Advanced, I think...]
#9

[eluser]Lewis Cowles[/eluser]
Just to keep you all updated I have heavily optimized the query by passing pre-computed values for a rectangle point check (for broad-phase check) using xmin,xmax,ymin&ymax; on the latitude and longitude, it does require having a valid postcode to search from but it has returned three results in 0.006seconds, for the broad phase check and 0.037 seconds for the full radial search within that result set, I'm still working on it, but i'll post the code here when I'm done so others can learn from it, Googles example for postcode search is terrible!


Messages In This Thread
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 02:33 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 02:44 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 03:28 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 03:33 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 08:48 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 09:53 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 11:07 PM
SQL [Advanced, I think...] - by El Forum - 07-19-2012, 11:11 PM
SQL [Advanced, I think...] - by El Forum - 07-20-2012, 05:51 AM
SQL [Advanced, I think...] - by El Forum - 07-20-2012, 08:11 AM



Theme © iAndrew 2016 - Forum software by © MyBB