Want to optimise my asp database queries - how many queries are too many?
Posted on 2005-04-29
I am building an ASP application to help students learn another language. The application contains 47 exercises. Each exercise is almost identical in terms of question structure. There are three multiple choice questions per page, but each question can have a differing number of choices. therefore, to build the pages dynamically using one ASP template, I have to make three database calls, one for each question.
A student can also save his answers, and I have to retrieve them, that makes three more database requests.
On this page, I also have three other database requests for different reasons.
That makes a total of 9 database SELECT statements each time an exercise is loaded.
(Once the selects are done, the recordsets are loaded into arrays and the recordset is closed.)
Is that too many database SELECT statements per page considering that hundreds of people will be using the application simultaneously? Is that a big server load??