Hi, just quick question on db design.
I have one table called Relations which can store many-to-many relations to different objects. Items will be referenced by id, type numeric keys.
Structure:
parent_id int
parent_type int
child_id int
child_type int
sort_order int
There may be millions of records inside this table, so it would be accompanied by some other preordered table(s).
can you see any problem with this aproach? Performance or scalability related?
