[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