Could someone explain to me why this behavior is, and how serious it can be depending on the number of fields? I understand that databases and tables, columns tend to slow down more than rows, but I don’t really understand why and if it is related to this. I would like to understand the root of the matter.
Does the same thing happen with clozes or do they have a different behavior? Will the performance of having a note with 200 clozes be the same as that of 1 note with 200 clozes?
To a large extent my interest in this matter comes from the fact that I am trying to migrate the modeling of my collection with closet, the new add-on from @hengiesel. It has many advanced cloze options, but it simulates cloze behavior with a field for each occlusion, and I am concerned that this will affect the performance of my collection.