Which is the best way to connect SQL server2014 from VB.NET 2015

Question

0.00/5 (No votes)

See more:

Hello,
Good Day!

I need to know what is the Best, The Most Efficient and The Fastest way to connect MS SQL SERVER 2014 Database using VB.NET 2015

I am also working in this combination but the problem is that when is execute a query directly in the SQL Server Query Editor it retrieves the the data that is consisted of almost 10,000 rows in just 1-2 seconds.
But when i execute the same query in VB.NET application and fill the datagridview it consumes 30-40 seconds that means the 20 times slower that the actual retrieval time of the query.

Please anyone can help me to figure it out what the mistake is in fact.

Thanks
Muhammad Asim Mughal

What I have tried:

I Need A General Solution without sharing the code specifically.

Posted 27-Nov-17 0:25am

Muhammad Asim Mughal

Updated 27-Nov-17 0:38am

Add a Solution

Comments

CHill60 27-Nov-17 6:35am

It would help if we could see your connection string (remove any sensitive information first) and exactly how you are populating your datagridview. Use the Improve Question link to add this information to your post

Muhammad Asim Mughal 27-Nov-17 8:57am

Sir,
Thanks for giving your time.
My actual question is that if the natural time of a query is 2 seconds then why it takes 40 seconds when it is called in VB.NET Application to fill the data in a DataGridView ?

CHill60 27-Nov-17 11:25am

It depends on
a) How you connected to the database
b) How you are populating your DataGridView
There is no one single answer to your question

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2017-11-27T00:38:00

Generally you should not query a lot of rows, you should page the results for performance reasons.

The DataGridView has a lot of overhead for displaying rows, your actual query results should take the 2 secs you mentioned (if it is done on your client machine, if not then you also have the network overhead to consider).

If the query on SQL Server takes 2 secs for 10,000 rows then you should look into indexing your query properly (it should be faster I presume but can not be sure since I don't know the details of your query schema, tables and columns used).