
May 4th, 2001, 06:51 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
SQL 2000 Slowsdown when using 2 recordset on one connection object
<i><b>Originally posted by : Thomas Rojsel (thomas@netit.se)</b></i><br />SQL 2000 Slowsdown when using 2 recordset on one connection object. Was running great when using SQL 7.0, other wise like the current.<br /><br />------<br />SQL server waits 4 seconds before returnung records after every request on the asp-page.<br /><br />Any ideas?<br /><br />Running:<br />SQL 2000, NT 2000, MDAC 2.6.<br /><br />Thanks,<br /><br />/Thomas<br />
|