In below there is question and answer, What I need is I want comment about the a

Question

In below there is question and answer, What I need is I want comment about the answer( feel free to agree or disagree with answer) in few paragraph

Question:
Connection Pooling is vital for a large scale enterprise application. Why? Discuss.

Answer:
The idea behind pooling is to combat the need to handle the issue that making connections to databases is actaully very long and tedious and requires effort. If in a large enterprise effort.... Forcing clients to make these connections become an exponentially large problem as you add users. (and on a micro scale.... we have to note that a user may want to make several SQL queries maybe slightly closely intertwined.... sooo not only does connection pooling help multi user issues it handles the fact that users may want to try to connect several times to make many queries) So the pool maintians and saves connections so that there is no reconnection overhead.

Explanation / Answer

Yes,I do agree with the above statements.Instead of wasting time for executing the same commands multiple times,Its great idea that connection pooling helps in establishing conections for the past executed statements without compiling them once again.This increases the performance of Command execution.Especially for the large scale enterprise inorder help their clients.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.