Hi, We have implemented a vb.net frontend that access a SQL-Server via VNP. Actully the frontend retrieve several dataset and show them to the user. The problem is that some of those dataset have more than 25.000 rows so it slowdown the program. My question is: 1) Is there a faster way than VNP to access SQL-Server via internet?, if so is it secure?. 2) Any suggestion on how to handle a "big" dataset so it do not slowdown the program?. Thanks, jamie
Hello James, Can't say anything about point one, but about point two - what's the way of getting data do u use? DataSet? Look at Datareader, it's about 30 time faster then DataSet J> We have implemented a vb.net frontend that access a SQL-Server via J> VNP. Actully the frontend retrieve several dataset and show them to J> the user. The problem is that some of those dataset have more than J> 25.000 rows so it slowdown the program. My question is: J> 1) Is there a faster way than VNP to access SQL-Server via internet?, J> if so is it secure?. J> 2) Any suggestion on how to handle a "big" dataset so it do not J> slowdown the program?. --- WBR, Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour "At times one remains faithful to a cause only because its opponents do not cease to be insipid." (c) Friedrich Nietzsche
