best way of executing long run query in vb.net

Last Reply on Mar 15, 2018 01:09 AM By Gayatri

Posted on Mar 15, 2018 12:49 AM

How to run long run query in vb.net

When i run the query timeout occurs and stop working. I have set command time out also but same problem occurs

You are viewing reply posted by: Gayatri on Mar 15, 2018 01:09 AM.
Posted on Mar 15, 2018 01:09 AM

Try this

modify connection string in web config

Connection Timeout=120;Connection Lifetime=180;Min Pool Size=0;Max Pool Size=1000;Pooling=true