ArcMap 10.5 - Report Poor Performance

MichaelChretien — Tue, 17 Jul 2018 20:38:12 GMT

Hi, we're using ArcMap 10.5 to design some report for our client and facing really poor performance.

Environnement :

ArcGIS Desktop 10.5.1
ArcMap 10.5.1
Enterprise Geodatabase - Microsoft SQL Server 2016

We're trying to do a real simple report on 1 table.

The table contain informations about inspections (currently 206400 records and 25 fields)
The purpose of the report is to extract the number of inspections / per type / per inspectors
Runing the report in ArcMap takes around 8 mins.

Seing this i've runned a direct query on the database to obtain the same information and i did the same in excel via a database link.

Sql query takes less then 1 second
Excel pivot tables takes around 15 sec to refresh

The SQL query i used to get the informations :

select distinct(territoire), statutInspectionFinal, count(*)
from [xgi0100_geoinspection].[dbo].[XGI1105CE_INSPECTION_EVW]
group by territoire, statutInspectionFinal
order by territoire, statutInspectionFinal

I've read all documentations available and it seams there is no way to pass a real sql query to the report builder (U can only add expression to the select * query that is generated by the report builder)

Questions :

Is there a way to improve performance of the ArcMap report ?
What alternative is available for customers to generate report ?

Every Comments would be much appraciated.

Tks

Michael

Re: ArcMap 10.5 - Report Poor Performance

AndresCastillo — Tue, 17 Jul 2018 21:17:39 GMT

regarding arcmap performance:

In the past, I Took some suggestions from the Github article to make ArcMap faster By Kevin Godsey

https://github.com/ncss-tech/geo-pit/wiki/How-to-Make-ESRI-Desktop-ArcMap-Faster

topic Re: ArcMap 10.5 - Report Poor Performance in ArcMap Questions

ArcMap 10.5 - Report Poor Performance

Re: ArcMap 10.5 - Report Poor Performance