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
Jul
3
answered Compressing the service definition failed
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
revised Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
No poll like structure to the question
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
revised Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
added 41 characters in body
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.
Jun
24
asked Understanding Number of Feature Classes vs Connection Time with Enterprise Geodatabases
Jun
11
awarded  Taxonomist
Apr
1
awarded  Popular Question
Mar
27
awarded  Popular Question
Mar
24
awarded  Popular Question
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
Mar
10
asked Database connection times - PostGreSQL vs Oracle (ArcSDE)
Mar
2
revised How do you symbolise a 32-bit raster in ArcObjects?
deleted 118 characters in body