Solved

VB.net SQL Versions and speed

Posted on 2015-01-23
4
82 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:murbro
4 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 167 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 167 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 33

Assisted Solution

by:it_saige
it_saige earned 166 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:murbro
ID: 40585458
Three great answers. Thanks!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

770 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