Latest Contributions by MattLane

‎05-01-2014

You can use the esri.request class to access standard web services https://developers.arcgis.com/javascript/jsapi/esri.request-amd.html

‎05-01-2014

The metadata's Geoprocessing History proved to be the culprit. My processing has dropped to 1/8th the time it was taking. The lengths of the metadata fields for the two feature classes in the GDB_ITEMS table went from 27million and 19million in length down to 1500. Thanks George, you're my new hero!

‎04-30-2014

No, this isn't previewing the data, this is just clicking the name in the contents tab. As in I want to right-click and select properties, which freezes ArcCatalog for 2 minutes before it shows the right-click menu. I have software info in the initial post, I don't have hardware or network info and will have to ask. I can tell you that the DB servers are virtualized with 16gb of memory, and I have had the DBA restart the server to "free up memory" which didn't help in the slightest. There is only 1 user during the day intermittently. I'll point out again that this has been a constant degradation over time. Things that used to be instantaneous on the dataset now take up to 4 minutes to do. I guess I'll contact support today. Thanks everyone.

‎04-29-2014

I have two unversioned featureclasses in a dataset that our organization adds and deletes up to 10s of thousands of records daily. One is over 3million points and the other is over 500k lines These were created in ESRI software and are edited with python tools outside of an edit session. They are not versioned (yet) but do have GlobalIDs. They will be replicated. They exist within a dataset, but exporting them out of the dataset into the main directory does not help. They were not like this 3 or 4 weeks ago, and there haven't been significant total record increases. Thanks for following up with me.

‎04-29-2014

I'm still unable to get the two layers back to where they were a few weeks ago. They continue to get worse by the week 😞 I've followed your suggestion, ordering the geometries by the districts they are in, proved by using the TOP keyword in SQL Server. After rebuilding all the indexes the issue persists. The display of the data in ArcMap is actually really fast. But adding it to ArcMap takes minutes. Just selecting it in ArcCatalog freezes the application for minutes. Other layers in the database, even fairly large ones, are instantaneous. This all makes me think there is some cruft in the SDE tables, or at least something wrong in them. I've tried copy/pasting them into a new layer or importing into a new layer (even without the GlobalID field) and the new layers are just as slow.

‎04-21-2014

If the feature data has been gathered over time it is likely badly spatially fragmented. One of the hallmarks of spatial fragmentation is poor spatial query performance, not matter how artfully the spatial index has been tuned. There are many possible ways to defragment spatially, but the easiest is to do an ORDER BY query on some attribute that imposes spatial order (county code, etc). More exotic queries are available if you can use the ST functions to group features into bands in X (or Y), then order by Y (or X). Note that spatial defragmentation will hurt join performance on other query constraints (like time), so that may need to be mitigated. Thanks Vince, I'd like to look into how I can reorder the data without reloading it. How do I go about using an ORDER BY like you mentioned to defragment spatially? Are you referring to enforcing order during spatial index creation or just on queries to the db?

‎04-21-2014

Thanks for the response. The records are being deleted by the delete tool and added by the append tool outside of an edit session (python scripted process). Like I mentioned, I'm monitoring the indexes and when a spatial index's fragmentation is > 30% I'm rebuilding. If the fragmentation is > 5% and < 30% I'm reorganizing. I've tried using ArcCatalog to Recalculate as well as delete and recreate. It seems to do what the SQL Server functions do and neither improve access and editing times.

‎04-21-2014

This has happened in the past and the only way I could find to fix it was to export and recreate the two layers completely. That worked well for about 4 months. This option won't be desirable once we start replicating daily to other agencies.

‎04-21-2014

I have two unversioned featureclasses in a dataset that our organization adds and deletes up to 10s of thousands of records daily. One is over 3million points and the other is over 500k lines. Each have an organizational ID field with an index and a GlobalID field with an index. We will be versioning and replicating these in the near future. They are getting slower and slower over time, to the point where just deleting a couple records could take 8 minutes and getting a table feature count using the toolbox tool takes 3 minutes. The processing that used to take 1 to 2 hours now takes over 12. Details: SQL Server 2008 R2 SDE Release 101010 Desktop 10.1 sp1 Each spatial index is built by ESRI (16 cells per object, Medium on all levels) Data is not in SDE schema, but a separate one There isn't a lot of other data in this database, although there is a single versioned featureclass in a different dataset that has topology rules applied to it. What I've tried: I rebuild and reorganize all indexes in this database as needed according to Microsoft documentation Checked the Bounding Boxes on the spatial indexes Rebuilt statistics (esri tools) Compressed Shrunk database (our DBA does this periodically) Restarted server (memory doesn't seem to be the issue)

‎04-14-2014

What does it mean to create a custom proxy on my servers? Does it mean just adding an additional URL reference in the proxy.config file that might be found in a Proxy folder on the webserver? <serverUrl url="http://gis.fema.gov/REST/services/NSS/FEMA_NSS/MapServer/0" matchAll="false"/> I was referring to making my own web service, similar in function to the esri proxy, that would just relay and return all requests to a specific third party service.

‎04-14-2014

the recommendation when designing SSL sites is definitely consistent use of the protocol Sorry if I sound frustrated, but it would be consistent use of the protocol if the CORS check honored the proxy rule. Why allow me to set a proxy rule for a service and then not use it for all calls to that service?

‎04-11-2014

Hey John, thanks for the reply. Unless I'm missing what you are saying, my problem isn't my own servers, they are all ssl enabled and fully certed, it's requesting layers from others (namely gis.fema.gov, see example). Using the proxy on my server for services on that server works great, it's the initial check for CORS that you mentioned that disregards the proxy and causes me the http over https warning that is giving me indigestion. It seems my options are either go forward with warnings from the browser, convince fema to enable https traffic on their servers, or create a custom proxy on my servers.

‎04-11-2014

To summarize, I can't use the proxy in an https site to load AGS services from a non-https site without getting the mixed content warnings and scaring away security conscious users. The first call to the host server for server info/capabilities just never seems to use the proxy. Would love to hear from ESRI about this.

‎04-10-2014

I recently added an ArcGIS Server layer to a web app where the source does not support https. I've set up the addProxyRule, configured the proxy config, and the layer loads just fine and I can see the proxy being used in the network traffic. However, the initial request to the rest/info?f=json is always without using the proxy, and it causes my page to lose it's end-to-end security because it 'displays insecure content'. Is this a bug in the api? It exists in 3.7, 3.8, 3.9. urlUtils.addProxyRule({ proxyUrl: '/proxy/proxy.ashx', urlPrefix: 'gis.fema.gov' }); fl = new FeatureLayer('http://gis.fema.gov/REST/services/NSS/FEMA_NSS/MapServer/0'); The page at 'https://<MYURL>' was loaded over HTTPS, but displayed insecure content from 'http://gis.fema.gov/REST/info?f=json': this content should also be loaded over HTTPS.

‎04-10-2014

Not sure, haven't tried that yet. I guess you could delete the cookie and reload the page.

Online Status	Offline
Date Last Visited	‎03-21-2023 08:19 PM

My Ideas

Latest Contributions by MattLane

Re: Any sample of how to call a web service

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Re: Non-versioned data slowing way down

Non-versioned data slowing way down

Re: addProxyRule and insecure rest/info checks

Re: addProxyRule and insecure rest/info checks

Re: addProxyRule and insecure rest/info checks

Re: addProxyRule and insecure rest/info checks

addProxyRule and insecure rest/info checks

Re: logout when page is reloaded