[OSM-dev] rails schema + mysql on dev v slow

Lars Aronsson lars at aronsson.se
Tue May 15 21:29:37 BST 2007


SteveC wrote:

> visible:
> 
> 1 = there
> 0 = deleted
> none returned = not created yet

Is there any difference, performance-wise if instead we'd have 
NULL = deleted ?  AFAIK, NULL doesn't get indexed, so the index 
might be smaller.  You could then not use the index for finding 
the deleted records, but do we ever use it for that?



-- 
  Lars Aronsson (lars at aronsson.se)
  Aronsson Datateknik - http://aronsson.se




More information about the dev mailing list