As it works in VFP, the main bank is broken up into smaller banks, so I grab all the identifying criteria at the start and hold that in a temp table (around 400 items) in memory, once the next question is chosen - I just pull that question from the SQL DB. Most of the statistical 'heavy-lifting' is done on the VFP side, which I'll need to convert to the back end - if I can.
>>
>>Can't - it's an adaptive test, I don't know what the next question is until they answer the last one.
>
>Any way to make some educated guesses ? Fetch all the possible next questions - discard the ones you don't need
>
>How many questions are there possible in one test ? Bring them all in
>
>
>Keep a pool of questions in a dictionary. If it is in, take it from there, if not fetch it
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place