Answer / madhunathanv

Connection pooling increases the performance of Web
applications by reusing active database connections instead
of creating a new connection with every request.

Connection pool manager maintains a pool of open database
connections. When a new connection requests come in, the
pool manager checks if the pool contains any unused
connections and returns one if available. If all
connections currently in the pool are busy and the maximum
pool size has not been reached, the new connection is
created and added to the pool.

When the pool reaches its maximum size all new connection
requests are being queued up until a connection in the pool
becomes available or the connection attempt times out.

Answer / d. shyamala

When a connection is opened for the first time a connection
pool is created. Connection pooling works only when the
connection string is same. New connection object is not
opened for two connection requests having same connection
string. This is called as connection pooling.

Answer / madhunathanv

Apart From def of Connection Pooling
Connection pooling has 4 parameters:

1.)Connect Timeout - controls the wait period in seconds
when a new connection is requested, if this timeout
expires, an exception will be thrown. Default is 15
seconds.
2.)Max Pool Size - specifies the maximum size of your
connection pool. Default is 100. Most Web sites do not use
more than 40 connections under the heaviest load but it
depends on how long your database operations take to
complete.
3.)Min Pool Size - initial number of connections that will
be added to the pool upon its creation. Default is zero;
however, you may chose to set this to a small number such
as 5 if your application needs consistent response times
even after it was idle for hours. In this case the first
user requests won't have to wait for those database
connections to establish.
4.)Pooling - controls if your connection pooling on or off.
Default as you may've guessed is true. Read on to see when
you may use Pooling=false setting.

Give an example that shows how to execute a stored procedure in ado.net?

0 Answers  

---

What is ado.net explain with diagram?

0 Answers  

---

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

---

What is the difference in record set and dataset?

0 Answers  

---

What is the default timeout specified for "sqlcommand.commandtimeout" property?

0 Answers  

---

What are the advantage of ado.net?

0 Answers  

---

Does dapper use ado.net?

0 Answers  

---

How to identify the updated rows in a dataset?

0 Answers  

---

Why is it important to close an ado.net application?

0 Answers  

---

Diff b/w DataReader,Dataset and Data table?

5 Answers   HCL,

---

What is the difference between SqlCommand and SqlCommandBuilder?

0 Answers  

---

How many types of data table are in SQL.NET

4 Answers   Chetu India, HCL, MAHINDRA,

---