taking python enterprise level?...
tim.wintle at teamrubber.com
Thu Mar 4 16:29:23 CET 2010
On Wed, 2010-03-03 at 16:23 -0500, D'Arcy J.M. Cain wrote:
> On Wed, 03 Mar 2010 20:39:35 +0100
> mk <mrkafk at gmail.com> wrote:
> > > If you denormalise the table, and update the first index to be on
> > > (client_id, project_id, date) it can end up running far more quickly -
> Maybe. Don't start with denormalization. Write it properly and only
> consider changing if profiling suggests that that is your bottleneck.
Quite - and I'd add to cache reads as much in front end machines as is
permissible in your use case before considering denormalisation.
> With a decent database engine and proper design it will hardly ever be.
I completely agree - I'm simply responding to the request for an example
where denormalisation may be a good idea.
More information about the Python-list