span8
span4
How can I improve the performance when working with Esri Geodatabases?
注意:ESRI的ArcSDE的已deprecated因此这不再是ESRI产品和FME的较新版本的选项亚搏在线娱乐平台
The Esri ArcSDE reader/writer generally provides better performance than the Esri Geodatabase (ArcSDE) reader/writer. This is because the Esri ArcSDE writer allows buffered writes, which can improve the performance of loading data you know will load cleanly. If you are concerned about performance, use the Esri ArcSDE writer if possible. You may need to create the feature classes with the Esri Geodatabase (ArcSDE) writer, then insert into them with the Esri ArcSDE writer.
The Esri ArcSDE reader/writer writes directly to the SDE feature classes avoiding the ArcGIS API used by the Esri Geodatabase (ArcSDE) reader/writer. You can only reader or write simple features with the Esri ArcSDE.
Try using the Esri Geodatabase (File Geodatabase Open API) reader/writer if you're only reading or writing simple features to a file Geodatabase. It avoids the overhead of the ArcGIS Geodb API.
您也可以尝试使用,而不是32位FME FME 64位。总的来说,FME 64位版本应该给你更好的性能。您可以使用FME 64位版本的读取或写入地理数据库,如果你安装64位地理处理引擎,是指在ArcGIS:Esri Formats Supported by my FME Version
您可以加快涉及所有作家的翻译延长提交事务之间的间隔。Committing transactions is an expensive operation, and therefore it is recommended that you make the transaction interval as big as possible. In speed tests performed at Safe Software, changing the transaction interval from 500 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 transactions OFF 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.
For Esri Geodatabase, if possible, use the Transaction TypeTRANSACTIONS or NONE代替EDIT_SESSION(Personal, File) orVERSIONING(ArcSDE的)。EDIT_SESSIONorVERSIONINGhave a significant impact on performance. Your Geodatabase only requires this mode if it is versioned or if you have certain custom behaviours or triggers (i.e. loading network topology, you have relationship tables, etc.).
您也可以增加通过写功能的速度creating all the feature datasets, feature classes, and tables ahead of time从而使地理数据库作家只需要打开它们,而不是创建它们。尝试使用ESRI的XML工作空间文档的地理数据库模板来创建整个地理数据库FME开始写之前。
Make sure when you are updating, the update key field has an attribute index on it.
SettingSimplify Geometry至NOwill speed up geometry writing. Setting验证功能写入NOwill speed up writing features whose attributes are set to domain or subtype values. The values can be validated after the load using the Esri tools.
Avoid or minimize the number of annotation features, because writing to these is slow. It has been improved when writing annotations with no user-defined fields.
尽可能多的精度和空间分辨率,你只需要使用。如果你需要的是32位精度,设置该对作家特征类型的参数,而不是64位。如果你需要的是分米级的精度,不要用这么大的比例因子,你是给自己0.00001毫米准确性。在这两种情况下,你会随身携带和处理更多的数据比你需要。减少你的有效精度和分辨率应该加快速度,特别是对于大型数据集。事先警告,减少您的精度/分辨率可能会导致出界外的错误或多边形坍陷进入点问题,如果你不给你的数据足够的精度。
注意:ESRI的ArcSDE的已deprecated因此这不再是ESRI产品和FME的较新版本的选项亚搏在线娱乐平台
对于ESRI的ArcSDE的作家,下降空间索引和把层(空间列)到LOAD_ONLY模式。您可以通过预先做到这一点使用SDE管理命令和Python的后处理脚本。使用图层之前,你需要建立空间索引。此操作可能需要的时间量显著,但是从数据加载的角度来看,将底层SDE层到LOAD_ONLY模式可导致在性能上非常大的差异。设置SDE_GRID {0}某些特殊值会影响什么类型格为给定的DBMS这会影响性能创建。请参阅ESRI的ArcSDE的文档了解更多信息(http://edndoc.esri.com/arcsde/9.3/api/capi/schemaobjects/layers/layerinfoSetGridSizes.htm)对于地理数据库的作家,电网1的大小设置为0,这样做意味着一个空间索引没有得到负载建的,但在加载完成后,会自动建立。
确保数据库的作家是first writer in the FME Workspace navigation tree(right click on the writer and use Move Up). FME caches the data for second & subsequent writers so having the database writer first ensures features are passed straight through to the writer.
In the reader parameters, if you don't require domain or subtype information then turn off the option for this information
设置搜索的信封,以减少将由阅读器读取并传递到工作区特征的数量。搜索包络的也可用于剪切传入特征,以进一步减少数据量。也是在数据库级别所以性能进一步优化执行此操作。
Check that the settings on the Geodatabase reader忽略网络信息and忽略相关信息被设置为YES,如果您不需要网络或关系信息从地理数据库读取。这里甚至被认为是阅读要素类时,这个设置为YES NO网络信息的性能改进。
@ mjb4gisCorrect. The ESRI ArcSDE reader/writer is now called ESRI Legacy SDE.
©2019安全亚搏在线软件公司|法律