Well, consider a single database table that looks something like this: From_address to_address (possibly multiple addresses comma-seperated) headers spam_report subject
And we would have millions of those records in the database. Repeated entries, especially on to_address, means the data is hugely redundant. By normalising we are turning a text search across millions of records with redundant repeated data into a text search over a unique list, then an integer search over primary key (which of course is indexed). On Sun, Mar 8, 2009 at 9:37 AM, Lawrence Krubner <[email protected]>wrote: > > > > On Mar 8, 3:26 am, Gareth McCumskey <[email protected]> wrote: > > We had a speed increase because we had a lot of text searches in the old > > system, all going through text fields where the same values were repeated > > over and over. Its therefore a lot faster to search a much smaller table, > > where the text fields are unique, and find the value once, then use an ID > > comparison, being much faster to match integers than text. > > > In sounds like you got a speed boost from doing intelligent indexing. > What you are describing sounds more like indexing than normalization, > at least to me. > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
