It depends on how many you need per page. If more than 10 I would use option 1 (denormalize) and if less than 10 I would go with option 2. I just made up the number 10.
On Oct 6, 8:38 am, "Michael - afewtips.com" <afewt...@gmail.com> wrote: > I understand that inner joins on GAE are not allowed, so what is the > best practice for > retrieving data from related tables? > > Forget normalizing and just add the related data to the record when > the record is added? > > or > > Keep the data normalized and every time I need to show the data for a > bicycle, go get the brand name from the brands table? > > How do most get around the no inner join limitation? > > Thanks > Michael --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
