...
Clicking on the menu item will open up the Datalist. In a typical listing, we will have the pagination feature to traverse through records. For pagination to work, we will need to first (again) compute the number of records we have in total. The count query will kick in again this time around.
...
If the database server has stellar buffer or caching size/capabilties, then subsequent sub-sequent viewing of each pages will not be penalized by the expensive count query.
...