Many small queries - bad?
The first thing people ask about new CMS is how many queries per page does it make. In other words, number of queries is considered to be the most important performance factor by many people. My questions are:
1)Why? Is query overhead _that_ big?
2)What exactly creates that overhead?
3)How can I increase application performance without sacrificing good design? IMO, writing godzilla-sized queries and functions like retrieveUserWithPermissionsAndOtherStuff() is an awful practice.
Subject
Written By
Posted
Many small queries - bad?
August 26, 2005 11:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.