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

[Frederik Ramm]

Hi,

> > 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.

1. The above error message is not an indication of prepared statements
not being used (as MySQL will create such messages even if they are).

but

2. ActiveRecord, the ORM framework used by Ruby on Rails, does not
support prepared statements AFAIK.

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00.09' E008°23.33'