Hi,

I have Drupal 7.23 and Quiz 7.x-4.0-beta1 and mySQL table "quiz_multichoice_user_answers" is getting huge.
Now it's size is 15MB and 136,013 lines. Also "quiz_multichoice_user_answer_multi" has same amount.

My site lets users take quizzes without logging in, so these are just anonymous answers, and i dont need them to be saved.
There are average 600 users per day and they make average 20 multiple choise quiestions.

Is it possible to disable saving answers to database? Is this normal behaviour? Is this maybe a bug ? Or are those lines deleted automatically after some time ?

Comments

Sivaji_Ganesh_Jojodae’s picture

Sivaji_Ganesh_Jojodae CreditAttribution: Sivaji_Ganesh_Jojodae commented

@jukka79_, sounds interesting. It is likely that you need to have answers saved in both quiz_multichoice_user_answers & quiz_multichoice_user_answer_multi at least until you show quiz feedback / report. That is to keep the default flow uninterrupted. You could write a simple hook_cron() implementation to clean the old records.

djdevin’s picture

djdevin
Location Philadelphia
CreditAttribution: djdevin as a volunteer and at Cadmium commented
Issue summary: View changes
Status: Active » Closed (outdated)

This issue is being closed because it was filed against a version that is no longer supported.

If the issue still persists in the latest version of Quiz, please open a new issue.