Latest Contributions by VinceAngelo

Cross-database queries will usually have poor performance, which is part of the reason they're not supported by ArcGIS. In order to determine if anything could be done to improve this query, we'd need to know: How complex the "BOUNDARY" geometry is (number of vertices) The ratio of the area of the envelope of BOUNDARY the area of the envelope of PARCELS The exact time it takes to query BOUNDARY from a SQL prompt The exact time it takes to query all of PARCELS from a SQL prompt The exact time it takes to query the subset of PARCELS which intersect BOUNDARY from a SQL prompt The exact time it takes to query the view from a SQL prompt The exact time it takes to draw the view in ArcMap. The spatial index options used on the PARCELS geometry column index - V ... View more

Please move this question out of this place, and into a place where it might be seen by geodatabase experts (like Geodatabase).  You should also edit the original question to contain the information necessary to generate an answer, which would include: The version(s) of ArcGIS in use The RDBMS (with exact version) hosting the enterprise geodatabase ("ArcSDE" no longer exists) The exact command you issued to create the view The exact table definition of the view (especially datatypes) Confirmation that the view generates correct/desired results from a SQL prompt What you mean by "not able to see" - V ... View more

-51 is SE_DB_IO_ERROR, meaning the database failed to read the data. That doesn't have anything to do with anything in SDE.SERVER_CONFIG.  ArcSDE 10.0 (which is now Retired) was certified with Oracle 11gR2 (11.2.0.1), but there isn't much data on how it will perform with 11.2.0.4.  There have been eight major releases of ArcGIS since 10.0sp5 (counting 10.1sp1).  I doubt there's anything you can do to make 40-month old application software work flawlessly with 30 month old database software (which is what Vince's First Law of Compatibility​ is about).  Unfortunately, you need to shorten the "while" before those errors can be resolved. - V ... View more

What GDB capabilities/functions could be affected? All of them. Like any powerful tool, triggers could corrupt your geodatabase quite effectively (albeit unintentionally) -- corrupting versioning, altering domains, mangling relationship classes, ...  the list is endless, really.  Extreme caution  is recommended. - V ... View more

Case sensitivity in SQL-Server object naming generated the implementation design you are seeing.  If ArcGIS creates the tables, they will be all-UPPERCASE. Please also remember that there is no such thing as an "sde table" -- only enterprise geodatabase feature classes.  "There is no Dana, only ZUUL!" - V ... View more

That was '90, my last year in Redlands. [And yes, we are way off-topic, since regions weren't introduced until 5.1Beta/6.0 in '92] - V ... View more

Well, maybe. We called our Redlands co-ed league softball team the "Node-Errors" for a reason.  I still curse American Airlines for losing the bag containing that softball shirt (which featured a pseudonode at 2nd base, and a pair of dangles at 3rd base). ... View more

Regions could be used to implement a multipart polygon, but they could also be used to implement multiple overlapping single-part polygons (successive features). They were defined by routes (which were collections of arcs). Yeah, it was pretty amazing to pile all that information into one set of INFO tables, but, Oy!, pulling it back out again was a nightmare. ... View more

Technically, regions are still a part of the archaic "coverage" format, but the performance cost of the shared geometry model of coverages has driven them from the marketplace (by definition, polygon, route, and region I/O cost is at least twice that of the "whole shape" model -- It takes one pass to read the file blocks to determine storage, and a second pass to fill the allocated vertex buffer) . - V ... View more

As commented in the GIS Stack Exchange question, No.   ArcGIS for Server is designed to be deployed as multiple nodes servicing one site, not as multiple sites in one machine. Even if you deployed one VM for each server, you couldn't get much use out of a VM server with only 32Gb RAM (especially if you wanted more than one service in each site). You can actually model the behavior of this configuration using the Capacity Planning Tool (it won't be pretty). - V ... View more

A proxy is just a proxy.  They're very easy to write (trivial implementations can be done in 12-15 lines of Java, good ones in 120-150 LOC), and there's lots of samples out there. There's more of a philosophical issue at play here, though, since proxies aren't supposed to make changes to the URL, just switchyard requests.  And if your proxy is consuming URL parameters, what  happens if the applications start using that same key?  Do you change the proxy?  Escape the key to have the proxy rewrite it?  This is where complex proxies come from. One thing you can look at is hiding information in the HTTP request headers.  Getting the data in there can be a pain, and making it stay can be challenging through multiple hops, but it certainly wouldn't change the URLs. - V ... View more