Many-to-Many Relationships & Active Record Class

Many-to-Many Relationships & Active Record Class

El Forum
Guest

11-28-2007, 03:00 AM

[eluser]tonanbarbarian[/eluser]
I would recommend you just use a single query that joins all of the tables, and then processing the data and splitting it into the structure that you want.
Because for each news item you are doing a seperate query to find the categories, so if you have 200 news items you are doing 201 queries, rather than just 1 if you use a join and process it.

Messages In This Thread

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 09:00 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 10:07 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 10:16 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-27-2007, 11:32 PM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 02:44 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 03:00 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 08:41 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 09:00 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 10:07 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 11:02 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 11:49 AM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 12:33 PM

Many-to-Many Relationships & Active Record Class - by El Forum - 11-28-2007, 08:46 PM

Many-to-Many Relationships & Active Record Class - by El Forum - 12-05-2007, 11:02 PM