By alechko on

Hey all.

I have 2 node types, and I need to share taxonomy data between them.

Possible solutions:
1. Make each node type have fields for each taxonomy vocabulary, and saving the terms in each node.
2. Making only one node having the taxonomy fields, and using entity reference on the other node.

I'm looking to know the performance aspect as well as the limitations of each solution, for example,
I think that the 1st solution would increase the MySQL storage, as both node types will store the info, while the 2nd solution would be heavier on the CPU/RAM usage.

which one do you think would be better?

thanx.

⋅ Categories: Drupal 7.x

Comments

da_solver’s picture

da_solver commented

Hi,
I suggest collecting performance statistics, study the results, then make a decision based on your business requirement details.

So you would implement each scenario, and then load some test data. From there, you can use a load tester like Jmeter https://jmeter.apache.org/ to gather performance statistics under various scenarios (I.E. number of concurrent requests).

You can also the use a profiler like xdebug to analyze the internal implementation performance (e.g. code, database access, etc).

Hope that helps (at least a little).
Good Luck :)

alechko’s picture

alechko commented

I was hoping to hear some thoughts from someone who already faced this question, because I believe there's more into that decision besides current testing. But for now I haven't heard any ideas besides testing, so I think that's exactly what I'm gonna do. Thank you, again.