Depends on how you are storing them in mysql, if you are using a pair of decimal(10,6) columns, then the rounding will happen anyway.
But you mention 'geometry' which suggests you are looking at the spatial extensions, which may well use a different system. But either way roudning to 6dp isnt really going to hurt - unless you working to cm accuracy! - and doing the rounding will save you a bit of bandwidth over the wire anyway. 2009/1/1 Alan C <[email protected]>: > > I am working on a project to store routes and associated information > points. This is going onto a linux, apache, mysql, php equipped > server. > > Using the examples I now have my input system working so routes and > points can be converted into a series of coordinates. I noted that > advice about storing points in mysql as 10,6 and so have gone to a lot > of trouble to round all my points to 6 places in the clientside > javascript before passing them to the server. My intention was to save > space and processing time > > but . . . the mysql geometry documentation says coordinates are > stored as double precision numbers > > so, my question is . . . have I wasted all that effort because mysql > is going to store my rounded numbers as double precision anyway? > > > > > -- Barry - www.nearby.org.uk - www.geograph.org.uk - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
