[OSM-dev] MySQL on dev

Damian Sulewski Damian.Sulewski at Uni-Dortmund.de
Wed May 16 14:02:23 BST 2007


Hi,
Am Mittwoch, den 16.05.2007, 14:19 +0200 schrieb Frederik Ramm:
> (x,y,z,type,size) for each tile
>    foreach($TileList as $SqlSnippet){
> 
>      $Fields = "x, y, z, type, size, date, user, version";
>      $Values = sprintf("%s, now(), %d, %d", $SqlSnippet, $UserID,  
> $VersionID);
> 
>      $SQL = sprintf("replace into `tiles_meta` (%s) values (%s);",  
> $Fields, $Values);
>      mysql_query($SQL); 

As i understod it, only fields like time, user, and version are updated,
and all tiles in the set have the same values.

would an update like this not be more effective?

foreach zoomlevel 
        "replace where (a<x && x<b) && (c<y && y<d) && z==zoom) (date,
user,
version) values(...)"
        query;

so one, query per zoom level.

Or did i get something wrong?

Damian
-- 
Verification of concurrent C++ programs:
http://StEAM.cs.uni-dortmund.de









More information about the dev mailing list