>HI Guys,
>I am using visual Studio.net 2003 with sql server 2005. When I run a SQL Statement in the query analyzer it takes 11 seconds, when I put the same code in my c#/ASP.net program it takes 3 minutes and then times out. Can anyone help me.
>
>in code i am using sqldataadapter.fill to fpopulate a dataset
>
>TIA
Fred,
Not really an answer but a check.
If you create a simple SQL statement that'd execute fast and return just a few rows from same database and table(s) does it execute without a problem? If yes then my suspicion is that incoming data is so big that .Net is running of memory space to create the dataset (with lots of disk swap) or a connection loss problem. If not then sounds to be a connection problem.
PS: With .Net 1.1 it was much slower than it is with 2.0. Taking 11seconds in query analyzer, I think it is a huge result. Do you have a chance to test it with say VFP and/or htm with ADO and some J/VBScript?
Cetin