It's not suitable for doing calculation in the controller. I don't know how bad it is going to be if I go with the path that Niphlod suggested. I have about 1000 Points. You think your solution will work well? On Mar 14, 2012 3:34 PM, "Alan Etkin" <spame...@gmail.com> wrote:
> Is it not suitable for your code to do calculations in the controller > code before storing/updating data? > > On 14 mar, 05:19, Kenny <nis...@gmail.com> wrote: > > I just started programming in web2py from php. > > > > I know how to do it on Mysql and GAE(geohash or I forgot but there's > > another one) > > > > But it seems that SQLite doesn't support acos and asin. Is it true? > > > > Is there any other way around to calculate inside of Sqlite query? > > > > What would be the best way to do this? Should I just calculate > > distance after fetching the db? > > > > I tried to search it on Google but no luck.
