I'm still building my testing application. There have been a few changes in the scope of the project and I am returning for your expert advise.
Here's the situation:
A test has infinite chapters.
A chapter has infinite questions.
When a test taker enters the site, they sign in to their profile page. This page needs to list the chapters that have been passed, and the ones that are available to take.
I'm wondering when and best way to call data from mysql db, and weather or not to put the past/available questions into the session, or individual page requests.
Would there be any advantage to doing some of the "heavy lifting" by the mysql server?
Is that a clear enough explanation of what i need to do?
Thanks for your wisdom!