As I said, it depends on number of records. And how extensively you use this table. If almost each user-related query involve this table much better have straight JOIN condition then OR in it.
On Aug 29, 4:34 am, Pablo Viojo <[email protected]> wrote: > Based on my own experience using medium-sized tables the "or solution" is > slower than "replicating data solution" > Just my 2 cents. > > Regards, > > Pablo Viojo > [email protected]http://pviojo.net > > ¿Que necesitas?http://needish.com > > > > On Fri, Aug 28, 2009 at 2:35 AM, Miles J <[email protected]> wrote: > > > Your calling a few OR queries on a page, its not going to cause any > > slow performance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
