You are here: Popular Formats > Esri Geodatabase Reader/Writer > Improving the Speed of Translations Using the Geodatabase Writer

Improving the Speed of Translations Using the Geodatabase Writer

You can speed up translations involving the Geodatabase writer by lengthening the interval between committing transactions.

Committing transactions is an expensive operation and therefore it is recommended that you make the transaction interval as big as possible (or alternatively, if transactions are not needed, then you can turn them off).

In speed tests performed at Safe Software, changing the transaction interval from 500 (the default) to 1000 resulted in a specific translation being 2.5% faster. Changing the transaction interval to 5000 resulted in the same translation running 5.5% faster. Turning off transactions resulted in an improvement of either 12% or 19%. The performance advantages of changing the transaction interval or of turning transactions off will differ between various datasets.

Another way in which the speed of writing features can be increased is by creating all the feature datasets, feature classes, and non-spatial tables ahead of time so that the Geodatabase writer only needs to open them, rather than create them.