New information has come to light as we continued our due diligence in testing the installation of the Utility, verifying that vulnerabilities have been eliminated, and confirming that Adept operations function as intended. Our recent findings necessitated an update to the Mitigation Utility, which we posted to the Synergis Customer Portal on January 6, 2022.

The updated Mitigation Utility package (Critical Security Update Log4j Remediation Tool_Update1.zip) now contains additional steps that must be performed on your Web server(s). Please download this updated package from the Synergis Software Customer Portal. The instructions are updated (beginning on page 6), and the new ZIP file includes version-specific DLLs you will use to apply the additional steps required on your web servers. Again, you must perform these further mitigation steps to remediate Log4J vulnerabilities on your network whether your Adept environment(s) have licensed Adept Web clients or not.

Here is the link to the Log4J Technical Bulletin
WINNERS OF THE FORUM SURVEY!!
$25 Amazon Gift Card Winners:
--Leslie Follows
--Andrew Hallas
--Simon Koh
--Micah Conner

Synergis Software Tee Shirt Winners:
--Peter Parker
--Adam Schettler
--Steve Buchanan
--Don Adams
--Raghuraman Rethinavelu
--Christopher Wood
--Andrew Nyberg
--Jay Lovelady
--Ronald Thompson
--Mike Moffitt
--Brian Cranston
--Bill Beard
--Steven Emborsky

Adept Benchmarking Different SQL Versions?

BCranstonBCranston Forum Moderator Posts: 44 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 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.