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
Solved

VB.net SQL Versions and speed

Posted on 2015-01-23
4
84 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 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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

Suggested Solutions

Title # Comments Views Activity
Write to a printer using vb.net 9 39
How do sunrise and sunset times change with altitude 14 35
Very Large data in MYSQL 7 73
Need syntax help building hyperlink 2 25
Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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