In the current situation, every "save" click creates a new version,
When a course has a lot of questions and each one of them has a couple of versions - sometimes even 30+
The DB is growing fast with mostly "garbage" data (even changing a spelling mistake creates a new version).
we have reached a large DB with over 27 million questions which caused our system response
to be slow.

I suggest a couple of possible solutions-
1- do not create a version on every "save" click, however - let the user decide that he wants to create a version.
2- site setting to control enable/disable the use of question versions.
3- allow backup-restore processes without question versions that are not in use at quizzes.

Thanks