topic buffer size in ArcGIS Enterprise Questions

buffer size

jayasudha — Mon, 03 Nov 2014 04:49:57 GMT

Hello experts.

ESRI has suggested to alter MINBUFSIZE and MAXBUFSIZE in SERVER_CONFIG to improve loading performance.

We load thousands of shape files from ArcGIS 10.1 direct connect to Oracle 11g.

How to calculate the required value for this buffer size required ?

Thanks

Re: buffer size

VinceAngelo — Mon, 03 Nov 2014 15:24:08 GMT

You probably want to be careful about optimizing your configuration for upload, since that generally impairs query performance. It's okay at initial population, but not for a production database. I'm mostly involved in loading, and I've never changed those parameters. That sort of tuning is usually empirical anyway, so you're not going to find concrete formulas.

- V

Re: buffer size

jayasudha — Tue, 04 Nov 2014 04:17:20 GMT

Is this tuning applicable to direct connect ?

If yes, the memory consumed from local machine where ArcGIS is installed or takes memory from server machine where Oracle is installed.

Re: buffer size

VinceAngelo — Tue, 04 Nov 2014 15:13:21 GMT

Both Direct Connect and application server connections use the documented parameters (unless otherwise indicated by the documentation).

The transfer buffers exist in both the client and server DLL. With Direct Connect, both exist on the client (in different threads). The memory consumed by ArcGIS transfer buffers is likely to be on par with that reserved by Oracle (or any RDBMS) for clients. You would need to research the database utilization in database documentation.

- V