Please contact Technical Support so they can work with you to identify the root cause of the slower connection times at 10.0. We have gotten reports of this and need you to work with Technical Support to isolate the issue.
I don't think this is as much an issue with the upgrade from 9.3.1 to 10 sp2 as it is just making the jump from 9.x to 10.x. We went through this when we upgraded and a solution was not found. our larger databases have been left at 9.3.1 for speed issues.
We've been investigating NIM064663 and believe we have a fix for it. One thing we did find is that the issue referenced in the bug was primarily due to connections to the geodatabase using a Desktop client (like ArcCatalog), over a wide area network, such as the internet.
Very Similar, my organization was the cause for the creation of the NIM, it's nice to hear you're finding a solution. yes, it's over WAN. It is a T1 conncection though. We also experience the issue over a VPN connection.
We've never had an issue with this prior to 10. We've been an ArcSDE lab since I was hired. It's what I was hired to implement.
Like i said, this issue has caused us to have out inhouse server running at 9.3.1
The best way to receive updates is to contact Tech Support and start an incident. There are quite literally hundreds of ways to tune ArcSDE performance, but if you are experiencing a software issue, then it might not make a difference. - V
I reviewed the ticket for the NIM the other day, and while I can see that the date for last reviewed has changed, I can't see anything on my side.
I'm curious as to what the fix is shaping up to look like and a pssoible timeline. If we need to move this conversation to the ticket system or something, let me know. They really need to allow private messaging on the forums.
I don't work in Tech Support, so I'm certainly not the best resource for follow-up on incidents. Virtually all the tuning to be done with ArcSDE is at the database level (or higher). Most the tuning which is available at the ArcSDE level is in the transport buffers (and I've never made a change to them that improved performance). - V