Drupal reference performance

Question

I have a project have a lot of field need to be reference by each other.

Does anyone could give me some suggestion about this situation?

How was the performance of field reference? Should I just saving field by text rather than reference type? (And then render by my custom module code)

Answer 1

There is no performance issue I see with reference field. Reference field holds lot of other things

1. A table which keeps relationship between two entities which is exposed to other modules where references are saved as entity ids with no control of user input, whereas for text field you do not have much control unless you put validations and turn into almost what reference field is already doing.
2. Different contributed module are built around reference fields.
3. As an example you can expose reference fields as relationship to views module.
4. Text Field is definitely not a replacement for Reference field.
5. You would not like to get the performance boost for a reference field on the cost of its functionality.
6. If you have long list of entities to reference, keep the widget as autocomplete that can help in performance boost a bit.