I'm just wondering who have experience using Quiz with many simultaneous users? We are using Quiz in our local Drupal intranet as a 'Test Simulator'. It starts to slow down when 30 and up users are using it. Clicking on the 'Next' button to go to the next question takes more time as more users are logged in. (takes 5-10 seconds to display the next question, sometimes hang). We are running Ubuntu Server 10.04 on an IBM x3200 M3 with 4Gb memory. As sivaji pointed out to me that this is MySQL problem, I followed his recommendation. Able to lower Qcache_lowmem_prunes and it somehow improved though the slowness is still noticeable. Attached is Drupal sql report and mysqltuner output. Any input/recommendation is much appreciated.
Whats the type of your DB tables? MyISAM or InnoDB? To me, it sounds like table lock issue, but maybe, I'm on the wrong track there.
QUESTION: What version of Quiz is this?
A bit more data from another user "packetbrain": 15 people taking simultaneous exam on Quiz 6.x-3.0.... website was speedy for admin functions during exam... students complained of 20 second delays to load questions... didnt seem to get any errors, however... all results seemed accurate.
| Attachment | Size |
|---|---|
| sqlreport.txt | 3.6 KB |