Solved

VB.net SQL Versions and speed

Posted on 2015-01-23
4
86 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 143

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
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 …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 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