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: 224
Performance
|sql
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