If I'm a) limiting the amount of tags stored per bookmark to two, and b) only allowing users to use either none or one tag per search...
...I'm wondering which would make for faster queries out of the following two systems:
The "Toxi" system:
BookmarkID | Blah | Tag1 | Tag2 |
(so a query where a user has chosen to include a tag in their search would include....
WHERE BookmarkID = $bookmark
AND (Tag1 = $tag OR Tag2 = $tag)
(with columns Tag1 and Tag2 indexed)
Or, is there a better solution nowadays?
Thanks for your guidance.