Connection e modal window

[Max]

I have a datagrid that show a list of element.
I connect my web application to Oracle 8.1.7 with this connection string :

Data Source=xxx;User=xxx;Password=xxx;Persist Security
Info=no;Pooling=yes;Max Pool Size=20;Min Pool Size=1

via Microsoft Oracle Data Provider.

In this list when i click the element, the application show a detail page of
this element (in a modal window)

Sometimes this page (modal dialog) take much second and when i close this
window the connection is deleted (why don't remain in the connection pool, i
see this in Oracle DBA Studio)

Can you help me ?
Thanks

 

[W.G. Ryan eMVP]

Are you positive that you're closing the connecting ie
using(OracleConnection cn = new OracleConnectinon){
///rest of your code in here?

}

As far as load times-- it coudl be the web server, db server, the query, all
sorts of stuff. Do you have any more details about how you're doing things?
Are you caching by any chance? If not that should speed subsequent loads up.