Hello all.
I have a N+1 problem which I cannot solve. I have a sample app hosted here that shows the issue: https://github.com/davidmles/question_parts
This is how it works:
There are 4 models: question, question_part, answer, and answer_part.
A question has N parts, and also N answers. An answer has N parts. And an answer part belongs to an answer and to a question part (the one is answering).
An answer can be a draft or published. A draft does not need to have all its parts answered, while a published answer does need them answered.
The problem:
When an answer is created, but not all its parts are answered, and I try to publish it, validation will fail and the edit form will be shown again. When showing that edit form after validation failed, there will be a N+1 problem, as answer parts will load the corresponding question parts without eager loading them.
I have tried to eager load them, but then the edit form will not show the proper error.
How could I solve this? I have explained a bit better the problem in the app’s readme: https://github.com/davidmles/question_parts/blob/master/README.md
Thanks.