[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