Hello!
I use Joomla! 3.10.12 and AriQuiz 3.9.21.
When creating quizzes, a bank of questions is mainly used, when the quiz contains several categories of questions from the bank. The following are significant database values containing a large number of records.

_ariquiz 2 406
_ariquizbankcategory 15,731
_ariquizquestion 63 578
_ariquizquestioncategory 4 829
_ariquizquestionversion 110 647
_ariquiz_quiz_questionpool 45 289

Since some time it has become impossible to add/edit questions in the question bank, because... any such action causes the browser to freeze and sometimes even cause problems with the server.

Examples of URLs that lead to problems (id are random):

administrator/index.php?option=com_ariquiz&view=questioncategory&task=add&quizId=154
administrator/index.php?option=com_ariquiz&view=questioncategory&task=edit&categoryId=4889&quizId=2404
administrator/index.php?option=com_ariquiz&view=bankquestions
administrator/index.php?option=com_ariquiz&view=bankquestion&task=add&questionTypeId=1
administrator/index.php?option=com_ariquiz&view=bankquestion&task=edit&questionId=59635

In most cases the browser message (different ones were used: Chrome, Edge, Mozilla...)

This page isn't responding.
We can wait for it to....

I have my own VPS with a well-configured system. The log of slow requests does not show a problem, i.e. mysql works fine.
Everything is fine on the frontend, problems are only observed in the admin panel.

What can be done to solve this problem or does the extension architecture not allow the development of projects containing a large amount of data?
Thank you.

Hello,

100k records in DB should not cause problems when queries/indexes are properly used. MySQL supports ability to log slow queries. Could you contact your server support and ask to check/enable this log?

If it doesn't help to find the reason of the problem is it possible to see the problem anywhere?

Regards,
ARI Soft

sent to info@ari-soft.com

Hello,

We can't check the first two link (don't have permissions), for last 3 links. We see request which is used to load bank questions takes 2.5 - 3 seconds (due to sorting by question name, if change sorting to question ID it will work faster).

Could you specify what browser you use? We checked it in Google Chrome on Mac.

Regards,
ARI Soft

reply to info@ari-soft.com