caching performance

[JoshWhite]

I recently recached my basemaps and now I have having a lot of issues with poor performance.  I'm using the Flex Viewer and the areas that were within the AOI seem to load more slowly that previously.  Really the main thing I changed was to move my data from a file geodatabase to SDE and my AOI was a smaller area but the cache settings were unchanged.  I would note that the previous cache was done in 10.1 and the new one was done in 10.2 if that makes any difference.

[MichaelVolz]

How much slower are the cached mapservices using SDE in v10.2 compared to v10.1?

Would you be able to use v10.1 SDE to create your cached mapservices for a more direct comparison between SDE at both versions?

I don't know if this would matter, but have you tried using the standard Oracle Client instead of the instant Oracle Client and then compare metrics of the cached mapservices.

[TimCollyer]

Ok, I think I can now confirm that this really is a problem.

I started a generation of my "full" cache (I was just running some sample areas when I posted earlier).

Using 10.0 this would take about 30hrs. Running now on 10.2 we are up to over 48hrs and I think it's only about 60% through (that's a rough estimate, I run my cache over 27 different features classes and it's finished 16 of them).

My 10.2 environment is as close to my 10.0 as I can make it... The big difference (I think), is using the oracle client for direct connections as opposed to an SDE connection...

[JoshWhite]

My main frustration is that I kept hearing how much faster SDE would be and I switched and ran into all sorts of performance issues.  The main reason I switched was to start using feature services but I'm still the only Desktop user. 

Why should the data source affect caching if the database is registered as a data store?

[MichaelVolz]

Are you certain that it's the update to the feature class that is the root cause of the slowness that you are seeing?  I ask because some of my organization's GIS web performance slowed down considerably due to increased demand and we found the router was the bottleneck which is an expensive fix.  Maybe its a coincidence that you are getting heavier load on your servers and that is the real issue (This is just a theory).  Do you have a means of measuring the load on your GIS server(s)?

Can you revert back to your previous setup to see if the performance has degraded there so you could rule out the different datasource as the source of the slowness?