[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