ASP - Multiple Connections

• mdouglass

  Default port

  Points: 1412

  More actions

  February 22, 2006 at 9:15 am

  #167762

  Hi,

  On my IIS Server I have an SQL database holding 100,000 part numbers.

  In my ASP code I create multiple connections with multiple recordsets to the same database (different tables).

  Some of the queries are nested!

  Is this good practice or should I be creating just one connection the the database with multiple recordsets to the one connection?

  Thanks.

  Mike

• Jo Pattyn

  SSC-Dedicated

  Points: 32396

  More actions

  February 22, 2006 at 1:24 pm

  #622733

  One connection with multiple recordsets

  according to

  http://www.eruditesys.com/web-design-articles/optimizing-php-and-asp-code.html