[development] Moderation bit behavior

[Bèr Kessels]

Op woensdag 5 juli 2006 17:41, schreef Gerhard Killesreiter:
> > Yes, this position does require more joins. I understand there is a
> > penalty. I think that penalty is worth the simplicity and can be
> > overcome with better caching.
>
> I am not sure. Getting caching right is a difficult thing and getting
> queries to perform better is much easier.

Another one worth exploring would be to add views (not the module, but the 
MySQL thingy) in database.mysql(.views).inc 

That way a database layer could, under water, use views instead of 
such "expensive" joins. result: We use our tools better, we gain (a lot of) 
performance and most of all, we normalise our datastructure better.

I'm all for pragmatic approaches, like adding title fields because it speeds 
things up, even if they bring us further away from having a Good Design. 
But I am more for using the tools to their full power, they way "it is meant" 
instead of abusing the tools.

Bèr