Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-23 : 17:46:25
|
Rob writes "I have a quiz engine built with ASP that I need to allow for randomizing questions as a test taker takes the test.
I am reluctant to use a temp table to randomize the records because I fear that it may affect performance if I have too many people taking a test at once on my ISP hosted machine. And, I want to make sure that the test question order remains intact for the duration of their session.
Would it be a good idea to store the randomization seed in a session variable and rebuild the question order each time a page of questions is requested?
Note: My test engine will typically present 5-10 questions per page and may have 100 or more questions.
Thanks for any recommendations you may have.
" |
|
|
|
|
|
Another Random Record Question