Multiple database accesses or one massive access?

Posted by DudeOnRock on Programmers See other posts from Programmers or by DudeOnRock
Published on 2012-12-18T21:43:26Z Indexed on 2012/12/18 23:12 UTC
Read the original article Hit count: 223

Filed under:
|

What is a better approach when it comes to performance and optimal resource utilization: accessing a database multiple times through AJAX to only get the exact information needed when it is needed, or performing one access to retrieve an object that holds all information that might be needed, with a high probability that not all is actually needed?

I know how to benchmark the actual queries, but I don't know how to test what is best when it comes to database performance when thousands of users are accessing the database simultaneously and how connection pooling comes into play.

© Programmers or respective owner

Related posts about Performance

Related posts about sql