Member Avatar for semicolon

Is ther a fastest way to retrieve data from sql server like the sqlbulkcopy the fastest way to insert large data.?

  • 2 Contributors
  • 3 Replies
  • 74 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Mike Askew
Member Avatar for Mike Askew

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.

Member Avatar for semicolon

Aside from that, is there any concepts can you suggest?

sorry for the wrong grammer and spelling :)

Member Avatar for Mike Askew

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.