[Tilesathome] t at h server performance

[Christopher Schmidt]

On Sun, Dec 23, 2007 at 02:57:49PM +1300, Rob Reid wrote:
> Christopher Schmidt wrote the following on 23/12/2007 03:43:
> > Since low content tilesets may result
> > in many hundreds of selects / "REPLACE INTO"s, this process is the
> > primary slow part of the tileset processing. 
> >   
> Are you able to tell if there is much difference in processing time 
> between a low content tileset where the blank tile info already in the 
> database is just being verified/updated and a low content tileset for 
> which the blank tile info is being inserted for the first time. 

No, I can't really tell. I mean, we're still pushing several hundred
queries a second, so there's no real obvious way that I can figure out
to detect which part is slower than it used to be. My guess is that it's
both the SELECTs and the UPDATEs.

Regards,
-- 
Christopher Schmidt
MetaCarta