Reputation
772
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
8 25
Newest
 Taxonomist
Impact
~34k people reached

  • 0 posts edited
  • 0 helpful flags
  • 37 votes cast
Jun
26
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
@Vince - just such a wierd response, I'm not sure whether you are going out of your way to be rude and/or arrogant but it's certainly coming accross like it! Why are you assuming that it's likely we haven't implemented our db properly and I just haven't bothered to describe all the "wrong things" with my implementation - bizarre! I don't believe for one second there are "external forces" at play here - I know doing a trace on ArcCatalog, SDE connections produce lengthy queries to the DB, BUT more so with PostGres than Oracle. I suspect ArcCatalog is just not up to the job.
Jun
26
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
@Vince - fair enough, but ESRI doesn't say what the best practice amount of objects in a database is. In fact I think it's unaccpetable that ESRI charge a lot of money for a piece of software that can't perform on par/near par with the host RDBMS; it kind of undermines the whole reason for having an Enterprise ArcSDE in the first place. Thanks for at least confirming that you would expect a degregation of performance - at least I'm starting to think it's not something we have done wrong on the database implementation side. We just have to much data for ArcCatalog to cope. :(
Jun
25
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
I also thought the poll was NOT subjective and actually set out to garner research data, in turn it would have been a sample of data that could have been summarised and gone some way to provide an answer. Anyway the "poll" has gone.
Jun
25
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
Yeh but hang on here - if you connect to either database using plain vendor RDBMS tools e.g. Oracle Developer or pgAdmin - the connection is near instaneous - it's ArcCatalog here that seems to be the problem - but I just want to know for sure. Also I have been told by ESRI that the amount of datasets we have is unusual - and I'm not so sure thats the case, I think having 2000 datasets is not out of this world.
Jun
25
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
@Vince - by dataset I mean it in a more generic way, i.e. featureclasses, rasters, tables, not featuredatasets.
Jun
25
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
OK - I see your point, it's a great shame with such an active community we can't draw out some useful empirical research from poll like questions. I think some questions can't be answered without a poll - because one answer to one question from one or two people can't give you a full answer.
Jun
24
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
I have reworded. But I still need to ask the mini questions.
Jun
24
comment Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
It is a kind of poll, but the poll results in themselves actually provide the answer to this problem. However I have also asked for any solutions for connection time optimisations people may have found.
Mar
10
comment Database connection times - PostGreSQL vs Oracle (ArcSDE)
Each database runs on it's own seperate VM (HyperV).
Mar
10
comment Database connection times - PostGreSQL vs Oracle (ArcSDE)
Tried most of that @Mapperz
Aug
20
comment Opening a featureclass not being the owner of the data in SDE
OK - glad I talked it out with you. Agreed - it makes sense what you say. :)
Aug
20
comment Opening a featureclass not being the owner of the data in SDE
Well, I debugged the code where I get to the line as quoted in the question, and it shows "VIEWER.STREETS" as the featureclass its trying to open (in the exception, even though I am only passing in the source name of the featureclass without the schema owner details i.e. "STREETS"). The exception says "VIEWER.STREETS" does not exist, and that's kind of right as it's technically "EDITOR.STREETS", as "EDITOR is the data owner. In the test, I am connected to the workspace using an account - "VIEWER" with rights/permissions to view EDITOR data.
Aug
19
comment Opening a featureclass not being the owner of the data in SDE
But you can't have everyone accessing the database with schema owner credentials or sde connection with those credentials.
Aug
6
comment ArcGIS - IExtension.Startup() not launching
That worked for me - thanks Kirk :)
Jul
11
comment Display 3 maps equally
Thanks chaps - It would appear that is all to do with the css/margins gutters etc and the claro css or whatever theme you choose. Thanks for your help guys.
Apr
11
comment How to display a raster using Javascript API
I will also look at trying to create a Mosaic dataset in my python script, as you suggest.
Apr
11
comment How to display a raster using Javascript API
Thanks for your reply - I have updated my post with the error message I get when using the ImageParameters/getResultImageLayer code. Any ideas?
Mar
11
comment Using custom xml file with ESRI addin and deployment
That's been a great help for me - thanks very much :)
Feb
12
comment ESRI ArcMap Add-in Config.esriaddinx
How do you deploy the xml file to the Environment.SpecialFolder.ApplicationData folder when you distribute the addin file to your users? Is it a case of manually copy/pasting the file?
Jan
27
comment How to Verify if a FeatureLayer already exists?
Just reading this - I take it the extra data you save, gets stored in the MXD not the actual featureclass i.e. one stored in ArcSDE?