English

ArcGIS (Desktop, Engine, Server) File Geodatabase SQL Performance Patch

Summary

This patch resolves a attribute performance issue in the file geodatabase introduced in ArcGIS 10.6.1 and repaired as part of the 10.8 release. It primarily effects expressions involving LIKE. If you are seeing performance issues with your queries against a file geodatabase starting at 10.6.1 you should install this patch.

Description

Esri® announces the ArcGIS (Desktop, Engine, Server) File Geodatabase SQL Performance Patch. This patch resolves a attribute performance issue in the file geodatabase introduced in ArcGIS 10.6.1 and repaired as part of the 10.8 release. It primarily effects expressions involving LIKE. If you are seeing performance issues with your queries against a file geodatabase starting at 10.6.1 you should install this patch. This patch deals specifically with the issues listed below under Issues Addressed with this patch.


Issues Addressed with this patch


  • BUG-000131010 - The Find command in ArcGIS Desktop and ArcGIS Servers REST endpoint takes exponentially longer to execute from 10.6.0 to 10.6.1.
  • BUG-000119030 - Querying or selecting from a compressed file geodatabase over eight times in ArcGIS Desktop 10.6.1 is slower than in ArcGIS Desktop 10.5.1.

Installing this patch on Windows


Installation Steps:


The ArcGIS product listed in the table must be installed on your system before you can install a patch. Each patch setup is specific to the ArcGIS product in the list. To determine which products are installed on your system, please see the How to identify which ArcGIS products are installed section. Esri recommends that you install the patch for each product that is on your system.

  1. Download the appropriate file to a location other than your ArcGIS installation location.

  2. ArcGIS 10.7.1  
       
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-1071-BGDT-FGSP-Patch.msp
         Checksum
         (SHA256)
    CAC5706550D43C29A817442E272DE7F2487BB2F936698B984EECC7FA4EAEAFB5
       
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-1071-BGE-FGSP-Patch.msp
         Checksum
         (SHA256)
    EB3511F283E8FEA915218767E06935E8AC167B2E853ADDBB8CD082106B095D67
       
    ArcGIS Desktop ArcGIS-1071-DT-FGSP-Patch.msp
         Checksum
         (SHA256)
    311B1EE6E4585FF6FD8E4E00430143AF5D9A47B486B1B7D60ED1366AD1C8560E
       
    ArcGIS Engine ArcGIS-1071-E-FGSP-Patch.msp
         Checksum
         (SHA256)
    DB254D3DDA8FD4C68533F37EFFD9537C3ADB8D64A841AEFC15BC247DF1BC6B3B
       
    ArcGIS Server ArcGIS-1071-S-FGSP-Patch.msp
         Checksum
         (SHA256)
    ECC55E4F4FDECCBBB70A42CD6CF99AA5EF1D66FC189E49743EB47774F9BA2B7B
       
    ArcGIS 10.7  
       
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-107-BGDT-FGSP-Patch.msp
         Checksum
         (SHA256)
    D19192B4D61138507CD2E7ABF29E45F32586CA84866E5B640B8F257F6B3D059D
       
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-107-BGE-FGSP-Patch.msp
         Checksum
         (SHA256)
    46893353D624A187F7304A12803EEDAA0FBD9C513029CC86817ADA4ABE2CE2B6
       
    ArcGIS Desktop ArcGIS-107-DT-FGSP-Patch.msp
         Checksum
         (SHA256)
    5E188B89FDBBD0757168808796756B781EC0B3F69F9C8BFDAC2F641AF6FD021C
       
    ArcGIS Engine ArcGIS-107-E-FGSP-Patch.msp
         Checksum
         (SHA256)
    07963C36EA4A997D8F9004BF6FEAD0511C38C49DAF739280842CE5CCD7379028
       
    ArcGIS 10.6.1  
       
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-1061-BGDT-FGSP-Patch.msp
         Checksum
         (SHA256)
    C1B1C7E3A6D547D17CF72CD0B8DC24B74CCCC99293E48CD265A7640BB3AB4B8B
       
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-1061-BGE-FGSP-Patch.msp
         Checksum
         (SHA256)
    AA4AF4FB831994F3FAE574460C745FFD133C627E2F1E092F22B340929AD74EF4
       
    ArcGIS Desktop ArcGIS-1061-DT-FGSP-Patch.msp
         Checksum
         (SHA256)
    94AD6C25CCE238A5FE609554EBFC9E6FCD78C00DE5237F2F77B80324C33EC5B0
       
    ArcGIS Engine ArcGIS-1061-E-FGSP-Patch.msp
         Checksum
         (SHA256)
    6CE8CC13EA10C8D9C05BA67AC5904AC0B890623C9D0AB14EC0A3F2E423DB0835
       
    ArcGIS Server ArcGIS-1061-S-FGSP-Patch.msp
         Checksum
         (SHA256)
    911A23F6EF18CA6290A77572EC45B414C8097EE3CC6BCD76DCAD9D4472C1A763
       

  3. Make sure you have write access to your ArcGIS installation location.

  4. Double-click ArcGIS-<Version>-<Product>-FGSP-Patch.msp to start the setup process.

    NOTE: If double clicking on the MSP file does not start the setup installation, you can start the setup installation manually by using the following command:

    msiexec.exe /p [location of Patch]\ArcGIS-<Version>-<Product>-FGSP-Patch.msp


Installing this patch on Linux


Installation Steps:


Complete the following install steps as the ArcGIS Install owner. The Install owner is the owner of the arcgis folder.

The ArcGIS product listed in the table must be installed on your system before you can install a patch. Each patch setup is specific to the ArcGIS product in the list. To determine which products are installed on your system, please see the How to identify which ArcGIS products are installed section. Esri recommends that you install the patch for each product that is on your system.

  1. Download the appropriate file to a location other than your ArcGIS installation location.


    ArcGIS 10.7.1  
       
    ArcGIS Server ArcGIS-1071-S-FGSP-Patch-linux.tar
         Checksum
         (SHA256)
    B3B74A60C221EA5BA657B8C290AC7F4264A3C32D6D970999AA7D01DC78145C6D
       
    ArcGIS 10.6.1  
       
    ArcGIS Server ArcGIS-1061-S-FGSP-Patch-linux.tar
         Checksum
         (SHA256)
    5ACFB0959BE95A12F661F334D263746CBEC14824B008A544F0308117EE77B3C1
       

  2. Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.

  3. Extract the specified tar file by typing:

    % tar -xvf ArcGIS-<Version>-S-FGSP-Patch-linux.tar

  4. Start the installation by typing:

    % ./applypatch

    This will start the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.


Upgrade a geodatabase

When a hotfix or patch for ArcGIS has been applied, it may also be necessary to upgrade your geodatabase. See the Upgrade the Geodatabase section on the Geodatabase management page for your individual DBMS platform for more information.


Uninstalling this patch on Windows


    To uninstall this patch on Windows, open the Windows Control Panel and navigate to installed programs. Make sure that "View installed updates" (upper left side of the Programs and Features dialog) is active. Select the patch name from the programs list and click Uninstall to remove the patch.

Uninstalling this patch on Linux


    To remove this patch on versions 10.7 and higher, navigate to the <Product Installation Directory>/.Setup/qfe directory and run the following script as the ArcGIS Install owner:


    ./removepatch.sh

    The removepatch.sh script allows you to uninstall previously installed patches or hot fixes. Use the -s status flag to get the list of installed patches or hot fixes ordered by date. Use the -q flag to remove patches or hot fixes in reverse chronological order by date they were installed. Type removepatch -h for usage help.

    Restart your ArcGIS services

Patch Updates

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

How to identify which ArcGIS products are installed

To determine which ArcGIS products are installed, choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all products, hot fixes, and patches installed on your local machine.

Getting Help

Domestic sites, please contact Esri Technical Support at 1-888-377-4575, if you have any difficulty installing this patch. International sites, please contact your local Esri software distributor.