As a basic design question, I have a query with a function that searches on two variables. The two variables needed to process the query reside wherever the function is being called on the page, to give a Count of the rows returned.
There will be roughly 700-800 of these on the page total.
Right now there are only about 75 of these placed (function must be processed 75 times?) . But since I see a delay in opening the page already, now debating on whether to allocate the functions into several queries only for the reason of processing time down the road for when all functions are called on the page.
Generally, guess my question simmers down to this: do multiple queries on a single page process simultaneously and thus faster -- or one after the next, as it appears a single query would do for the 700-800 total? Functionally, the same single query could perform all Counts.
