SQL 2005 + Visual Studio 2005

[mantiz]

Paidia, sxediazw ena programma se ASPx (C# .Net) mesou tou Visual Studio 2005 to opio sindetai se mia basi dedomenwn SQL 2005. Topothetw ena DetailView se mia aspx selida kai to sindew me enan pinaka stin SQL mou, o pinakas autos einai ligo megalos, 800.000+ rows, kai gia auto isws ton logo argi ligo na fortosei i selida mou. Otan fortosei kai blepw sto DetailsView mou tin arxiki timi tou pinaka epilegontas next, gia na mou deixei tin epomeni kanei peripou 30secs gia na paei stin epomeni. Giati? Fortonei xana olo ton pinaka ston DetailsView? Iparxei kapios tropos na kanw tin oli diadikasia pio grigori? Kapio add-on? kapio allo control isws? Ama exete kamia idea... peite tin min ntrapite