On Tue, Oct 24, 2006 at 10:46:21PM -0000, Ed wrote: > What do you mean when you say that the data is not 'normalized'?
I'm referring to database normalization, which boils down to: store each piece of data in only one spot. Check here: http://en.wikipedia.org/wiki/Database_normalization or Google around for database normalization tutorials. So, using signals in this case is not normalized because the "average rating" field is redundant with the existing rating fields. The raw sql solution avoids that denormalization. If your primary concern is the design of the relational database, then you should absolutely try to normalize your system as much as possible. If your primary concern is the object model, and you have a decent ORM, then normalization is secondary. -johnnnnnnnnn --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---