Hi, I have a little problem and I would like to know which approach you would take to solve it.
Let's say you have two sql tables in a 1:N relationship, tables could be as follow:
relation would be 1:n tblItem:tblStat.
If you would have to search items that contains specific stats, how would you go about it?
I want an Item that have the following stats:
the item could contain 50 stats, but as long as those 2 stats are present then it's ok.
My current search is pretty crappy, while it is perfect fow a low database, when there are thousant of items with millions of stats, the search can take forever.
I am not looking on ways to tweak my current search algorithm, it is so crappy I just want to completly replace it. I am looking for approach suggestions.