Answer by Mitchell McKenna for stored procedure mysql
September 15 2010, 1:07pm
Your going to want to store as much data (such as the user's lat/long) in Session as possible. This way your not querying for this data, that's isn't really changing, on every page load.
http://stackoverflow.com/questions/3718458/stored-procedure-mysql/3719999#3719999