[symfony-users] Re: Symfony Production Performance improvements

[Lawrence Krubner]

On Mar 8, 3:26 am, Gareth McCumskey <gmccums...@gmail.com> 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 symfony-users@googlegroups.com
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---