Latest Contributions by JianLiu

‎06-27-2019

Hi, We have exactly the same issue, and don't have Carbon Black Sensor. Just wonder if anyone else has figured out and would like to share a resolution? We have Data Store and Portal installed on the same machine though. Not sure if that could contribute to the issue...?

‎06-27-2019

Hi Michael, I'm seeing the same 10.6.1 performance issue (on 2012 R2), and found your post here. Thanks a lot for sharing the info. I tried the approach on two of our machines, one seems to pass but the other won't start properly after the change, so I had to revert it back. A support analyst from ESRI Canada commented this is a risky change and not recommend it, not know why. Nonetheless, this doesn't seem to improve the performance even on the machine where it passed. I saw your other post here: https://community.esri.com/thread/229858-frequent-the-database-server-was-found-to-be-stopped-re-starting-it And I have exactly the same error logs as you showed. Just wonder if that could be the actual fix for the performance issue? We don't have Carbon Black Sensor though, and still need to track down what's causing the issue.. Thanks a lot for sharing the info.

‎10-16-2015

Our performance issue was due to some customization of the geocoder. We just resorted to the original locator files provided, which does seem to give faster performance. Sutharsan Suriya Prakash

‎08-05-2015

I am having the same problem too. ArcGIS 10.3, StreetMap Premium 2014 release 3. "Could not install the license". Have ESRI resend the licence, still the same error. Anybody has any idea what is going on? 2015.1 installed without any problem on that machine.

‎07-15-2015

I have the same problem too. My tif file name has a "." in it ("MN_Marine_on_St._Croix_20130807_TM_geo.tif"), the replacedatasource won't work! So I have to manually rename the file to make it work? Imagine I have hundreds of files... I am using 10.3.This seems to be an easy fix. ESRI, please.

‎06-12-2015

Mine is also a VM, Server 2008 R2, ArcGIS 10.3 It won't stop immediately after it's started though. It will be working fine. The problem is only at each startup -- the password will have to be changed...!!

‎06-05-2015

Mine turned out to be the same problem as above. But I don't understand how this could have happened, and it happens frequently. Something is always changing the password saved to the service, and I have to manually change it back to the right one. How could this have happened??! Dag Stenkvist Dag, did this happen to you too? Thanks.

‎06-05-2015

Brad Niemand Brad, Just want to share some new discovery with you -- The culprit for the slow performance seems to be due to the change of Min Match and Min Candidate Scores. The 87000records/hour performance is when those two were changed (e.g. to 93), but when I use a "clean" .loc and .xml files, the performance is back to about 200,000records/hour. I also noticed there are quite many other configuration items added to the .loc file when those two scores were changed through ArcCatalog. Regards, Jian

‎06-04-2015

Brad, To be clear, what indexes are you referring to by "The initial overhead reading the indexes from disk". Is it loading reference data in .lox file to the memory? I see ArcMap freezes for a while when I picked the locator and I thought that's when the indexes are loaded. Also I noticed the speed was around 180,000records/hours when the geocoder initially started working, but it dropped off to 80,000records/hours quickly in a few seconds. Not sure this might indicate anything. Thanks for the sorting suggestion. I will keep it for use against really huge data. In general, how would you comment on the rate of 87000records/hour? Is it normal? Or way below your benchmark during testing the geocoder? If it's within the normal range, I think I will leave it there. Thanks a lot for the help. Jian

‎06-04-2015

1. OS is Windows Server 2008 R2 standard, SP1 CPU: Intel Xeon X5660 @2.80GHz RAM: 8G 64bit 2. I use Multiple fields geocoding 3. It's a virtual machine, and I will have to ask our IT department to find out. How much improvement we may see from a HDD to a SSD just in case?

‎06-04-2015

Brad, thank you for the suggestions again! I've tested the two parameters as you've suggested, the performance IS much better now at around 87000records/hour. Thank you! It is two times faster, but still much slower than the older version. I would like to get a comparable speed if possible. I also tested RuntimeMemoryLimit = 4096MB out of curiosity, but it didn't help. What else could hinder the performance?....

‎06-02-2015

Just to add more information -- The geocoder is a composite geocoder, stored in a folder (not SDE etc.).

‎06-02-2015

Thanks Brad. We've done various comparisons and the results are not self explanatory themselves. Sometimes it could be better and sometimes worse. You are right that it depends on how good the cleansing tool is, and unfortunately I am not confident QAS is a good tool. If anyone sees this post, I would appreciate it if someone can recommend a good address cleansing tool. Thanks in advance. Also Brad, maybe I direct your attention to my other post here about geocoder again: new geocoder is so much slower than the old one Thanks for the information and suggestions! Regards, Jian

‎06-02-2015

We use StreetMap Premium geocoder, and just installed 2014R3 version. However, compared to the old one we had (2012R3, SDC based), this new geocoder is about 3 times slower. For example, the geocoding speed was about 130,000records/hour for the old one (using ArcMap 10.0), and 45,000records/hour for this new one (using ArcMap 10.3). I checked computer performance while geocoder was running, it doesn't look like CPU nor memory has reached its capacity, so geocoder performance should not be limited by my hardware or resource sharing. I am thinking if there is any major change in the geocoder itself that could lead to such a dramatic change??! I saw posts mentioning GDB vs. SDC. Anybody has the same problem? I encountered a number while googling: https://www.esri.com/library/whitepapers/pdfs/arcgis93-geocoding-technology.pdf page 6 mentioned desktop speed of 2,250,000/hour for batch geocoding (though it's an older version). I would be happy to get one tenth of it. How can I make the new geocoder run faster? Thanks a lot!

‎06-02-2015

Brad Niemand Brad, Thanks for the info! I will change the Minimum Candidate and Minimum Match Scores for AddressPoint to 93 to test. Thanks! A side question, but still kind of related to the geocoding algorithm --- Our current geocoding procedure is 1. address standardization -- prep clean the addresses, including removal of confusing or redundant components such as suite numbers or p.o. boxes 2. address "cleansing" using 3rd party software such as QAS (I don't quite know what's in their box) 3. feed the "cleaned" address to ESRI geocoder I have noticed there are various alias name settings in the .loc.xml files, so I assume the geocoder does address standardization as a prep step before doing actual address matching. So I was wondering if some of our procedures might be redundant? In all, I want to know what you would recommend as a cleansing step, in order to get the best out of the geocoder? Thank you. regards, Jian

Online Status	Offline
Date Last Visited	‎11-18-2020 06:40 PM

My Ideas

Latest Contributions by JianLiu

Re: Frequent "The database server was found to be stopped. Re-starting it."

Re: Portal for ArcGIS 10.6.1 slow after upgrade and troubleshooting

Re: new geocoder is so much slower than the old one

Re: StreetMap Premium License not Installing

Re: Using replaceDataSource to change geotiff file source?

Re: Error 1069: The service did not start due to a logon failure

Re: Error 1069: The service did not start due to a logon failure

Re: new geocoder is so much slower than the old one

Re: new geocoder is so much slower than the old one

Re: new geocoder is so much slower than the old one

Re: new geocoder is so much slower than the old one

Re: new geocoder is so much slower than the old one

Re: Geocoding Score Documentation: How is the score value determined?

new geocoder is so much slower than the old one

Re: Geocoding Score Documentation: How is the score value determined?

Re: what arcpy function does Data/Export Data corr...

Re: Frequent "The database server was found to be ...

Re: Portal for ArcGIS 10.6.1 slow after upgrade an...

Re: Geocoding Score Documentation: How is the sco...

Re: Geocoding Score Documentation: How is the sco...