Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

AriQuiz is very slow in bank questions
(1 viewing) (1) Guest
component
Go to bottomPage: 1
TOPIC: AriQuiz is very slow in bank questions
#71648
AriQuiz is very slow in bank questions 2 Months, 2 Weeks ago Karma: 2
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.
The administrator has disabled public write access.
 
#71649
Re:AriQuiz is very slow in bank questions 2 Months, 2 Weeks ago Karma: 747
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
The administrator has disabled public write access.
 
#71652
Re:AriQuiz is very slow in bank questions 2 Months, 2 Weeks ago Karma: 2
The administrator has disabled public write access.
 
#71663
Re:AriQuiz is very slow in bank questions 2 Months, 1 Week ago Karma: 747
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
The administrator has disabled public write access.
 
#71668
Re:AriQuiz is very slow in bank questions 2 Months, 1 Week ago Karma: 2
The administrator has disabled public write access.
 
Go to topPage: 1