Jump to content

Efficiency: array_intersect vs many-to-many


lastdoor

Recommended Posts

Hello

 

A question popped up in my head, while I was designing my database (this is both php and SQL thought).

 

The scenario is that an item can have many categories. Yet the categories are finite (<100 let's say).

 

I have no problem making a many to many link table. Yet I was wondering if the finite categories would necessitate this method.

 

My thought is - make the categories table a default array and match it against a queried item (containing an array of category IDs) with an array_intersect.

 

Is this efficient, silly, or a variable scenario?

 

Thanks for any insight.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.