.lyr files take too long to display in ArcCatalog 10.4

772
11
01-16-2018 06:28 AM
JoseSanchez
Occasional Contributor III

Hello everyone,

.Lyr files take too long to display in ArcCatalog 10.4 where datasource is an SDE SQL database.

Any ideas of how we can optimize that?

0 Kudos
11 Replies
MichaelVolz
Esteemed Contributor

What is the time difference if you get the data directly from the SDE SQL database instead of via the lyr file?

0 Kudos
JoseSanchez
Occasional Contributor III

Hi Michael,

Symbology. We have an AddIn to load dynamically several layers in a mxd using .lyr files.

This solution works very well in SDE Oracle, but in SDE SQL .lyr files are very slow.

0 Kudos
MichaelVolz
Esteemed Contributor

So you have the same data in an Oracle SDE database as the SQL SDE database and you can bring in the same data with the same symbology much quicker from Oracle than from SQL?

Perhaps the below patch was created for this issue you are seeing:

ArcGIS 10.4.1 for (Desktop, Engine, Server) SQL Server Quality Improvement Patch

https://support.esri.com/en/Products/Desktop/arcgis-desktop/arcmap/10-4-1#downloads?id=7422 

I do not use SQL for storing enterprise data, but at 10.5.1 my organization did need to apply a Critical Patch for the Oracle SDE database to work properly.

JoseSanchez
Occasional Contributor III

Hi Michael,

Yes, that is exactly the environment we have. And also we are migrating from Oracle to SQL.

Thanks

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

Where the layer files regenerated, or newly created, for SQL Server or was the data source just updated?

Are both systems (Oracle and SQL Server) live during the migration, or have you already shutdown Oracle?

JoseSanchez
Occasional Contributor III

Hello again,

Question: Where the layer files regenerated, or newly created, for SQL Server or was the data source just updated?

.lyr files were created in ArcGIS 10.2 with SDE Oracle.  All  .lyr files were copied in a new folder, and datasource updated with ArcGIS 10.4. to point to SDESQL.

Are both systems (Oracle and SQL Server) live during the migration, or have you already shutdown Oracle?

We are currently migrating in a development environment.  Both systems are live by the moment.

0 Kudos
MichaelVolz
Esteemed Contributor

How about bringing the symbolized data into ArcMap using the Oracle lyr files.  Then in ArcMap resource the data to SQL Server.  Then create brand new lyr files.  This should remove any corruption you might get from using the existing lyr files.  Rename existing Oracle lyr files as a backup so your Add-In can work with the SQL Server based lyr files.

JoshuaBixby
MVP Esteemed Contributor

My organization has run into issues resourcing older layer files to newer EGDBs.  As Michael suggests, it is worth trying to create new 10.4 layer files sourced directly to SQL Server (not resourced in existing layer).

0 Kudos
JoseSanchez
Occasional Contributor III

Michael, Joshua,

Sure, we are goimg to test Michael's solution.

We already changed the SDE datasource from one SQL instance to another and got better performance.

0 Kudos