Is ther a fastest way to retrieve data from sql server like the sqlbulkcopy the fastest way to insert large data.?
semicolon 0 Light Poster
Recommended Answers
Jump to PostMost likely using the standard provided classes microsoft have. and writing SQL that doesnt select redundant data, will be the fastest way in my opinion.
All 3 Replies
Mike Askew 131 Veteran Poster Featured Poster
Most likely using the standard provided classes microsoft have. and writing SQL that doesnt select redundant data, will be the fastest way in my opinion.
semicolon 0 Light Poster
Aside from that, is there any concepts can you suggest?
sorry for the wrong grammer and spelling :)
Mike Askew 131 Veteran Poster Featured Poster
Off the top of my head im afraid not, I usually just use the standard DataSet/DataAdapter to get information and its performance is fine.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.