On Wed, Jun 3, 2009 at 9:09 PM, Brian May <br...@microcomaustralia.com.au> wrote: > > Having composite pks can have a gotcha. For example, in my mysql based > database, my legacy application had the primary key (from memory) in a table > of > (photo_id,album_id) - this was a table linking photos and albums together. > However > the order of the primary key is important. So if I wanted to find a list of > photo_ids for a particular album_id (without any additional indexes), mysql > would > have to search the entire database because the photo id comes first in the > index, > meaning it can't be used. >
fortunately, i don't use mysql ;) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
