[OSM-talk] Parametrizing SQLs /was Re: gpx import problem?

Stefan Baebler stefan.baebler at gmail.com
Thu Sep 13 07:06:43 BST 2007


graham wrote:
> Mysql::Error: Column 'tile' cannot be null: INSERT INTO gps_points 
> (`timestamp`, `latitude`, `altitude`, `tile`, `gpx_id`, `longitude`, 
> `trackid`) VALUES('2007-09-10T15:00:35+00:00', 42455527, 442.343872, 
> NULL, 38444, 13926608, 1)
>   
Hi, wouldn't using SQL parameters everywhere speed up the DB operations?
AFAIK modern SQL engines generally recognizes identical SQL statements 
and can optimize things internally for most often executed stuff.

Stefan




More information about the talk mailing list