👉🏼 A Comprehensive Response on Apache Log4J Vulnerabilities 👈🏼

If your organization has not addressed the Apache Log4J Vulnerabilities in Adept or if you are not sure if this has been addressed, please read the following post with our comprehensive response on Apache Log4J Vulnerabilities .
Join us for the next customer webinar, PDF Magic: How PublishWave Automates High Fidelity PDFs of Your Drawings & Documents.

Here is a link to join!
Save Your Spot .

Adept Benchmarking Different SQL Versions?

BCranstonBCranston Forum Moderator Posts: 46 Moderator
edited November 2021 in Product Questions
Hi,

I'm curious, has anyone done any comparisons in Adept speed of any versions between SQL 2008 and 2016?  My SQL Admin has been educating me as they have started the process of upgrading our SQL systems to SQL 2016.  One thing mentioned was an improved query optimizer. I wondered if that might translate into a real world difference in Adept?  I probably don't have the transaction rate to notice anything but I thought I'd ask.

-Brian

Comments

  • Nick.BogartNick.Bogart Staff Moderator, Synergis Employees Posts: 12 Moderator
    I have not done that.  But, I've been wondering the same thing.  When running large queries, there is a noticeable difference between the time it takes to produce the results of SQL 2016 vs SQL 2008.  I've seen as much as a couple seconds difference when selecting say..."Select top 100 rows" of the FM110.cmd table.

    Nick Bogart
    Synergis Adept - Application Consultant

Sign In or Register to comment.