Improve company productivity with a Business Account.Sign Up

x
?
Solved

VB.net SQL Versions and speed

Posted on 2015-01-23
4
Medium Priority
?
114 Views
Last Modified: 2015-02-02
Hi

Does the speed at which VB.net interacts with SQL differ according to the version of SQL?
0
Comment
Question by:Murray Brown
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 668 total points
ID: 40565996
in short: no (well, maybe)

longer answer: when you move to a different server to use the different version, the servers usually are not configured the same way (different hardware etc). I have also seen some (sql default) settings that may need to be adjusted after the installation, which is usually not done when migrating, and often has a negative impact on the higher version, though it's not the sql version being the issue.

the normal result should be that with higher version of sql, you should be able to have at least the same speed, if not better.
0
 
LVL 11

Assisted Solution

by:LordWabbit
LordWabbit earned 668 total points
ID: 40566212
Usually the newer version would have been optimised more with better execution path logic, indexing etc.  BUT there are exceptions to this, where they mess up and release a product which may have newer features and functions but they cause the older functionality to operate slower.  Also if the code is not changed to make use of new features (like paging) and it is still being done the old way (OVER or god forbid temp tables) then you will not be getting any appreciable increase in performance.

Also would like to mention they way in which you are communicating with SQL Server can and will have a big difference in speed.  If you are using ODBC instead of the natice SqlClient libraries then there will be a big difference in performance, but this will hold true no matter which version of SQL you are using.
0
 
LVL 36

Assisted Solution

by:it_saige
it_saige earned 664 total points
ID: 40566587
One other thing (that was sort of touched on by Guy), you also need to understand the hardware that the software is running on.  When install the latest and greatest SQL server (and lets just say, for the sake of argument, that its the best performing, completely bug free version that Microsoft has ever introduced), you can expect the performance to directly reflect the hardware that is made available to it (minimum hardware requirements vs. below minimum hardware requirements vs. above and beyond minimum hardware requirements).  If you are installing the latest version of SQL because it outperforms it's cousins, then you need to ensure that the system you are installing it on meets (or even exceeds) the minimums.

-saige-
0
 

Author Closing Comment

by:Murray Brown
ID: 40585458
Three great answers. Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question