企业级地理数据库使用日志文件表来维护所选记录的列表。每次选择指定大小的内容时会将记录写入日志文件表以供应用程序之后使用,对版本化数据库执行协调或提交,或者在客户端应用程序中完成离线编辑检出。日志文件表中存储了所选要素的 ObjectID,这样便可重新显示这些要素。支持信息的更快速分析和处理。
在 ArcGIS 中,默认情况下,如果选择集包含 100 或 100 条以上记录,则会使用日志文件表。100 个要素这个阈值可在注册表中设置。可对此阈值进行更改;但 Esri 不建议进行此操作。没有任何证据表明更改此阈值可改善性能,对其进行更改可能造成性能问题。
默认情况下,SQL Server 中的地理数据库使用在临时数据库 (tempdb) 中创建的基于会话的日志文件。这是推荐设置并且足可满足大多数情况的要求。然而,如果想要更改设置,请参阅更改日志文件表设置。
When working with results in the workspace, it is best to understand the log file table configuration options so you can choose the right option for your database needs. There are four different geodatabase log file options: shared, session-based, stand-alone, and pools of session-based or stand-alone log files.
Common configuration options
For SQL Server, the default log file configuration is session-based log files created in the temporary database (tempdb). In most cases, the default geodatabase log file table configuration for your database management system (DBMS) should be sufficient and is the recommended setting. Another common option is the shared log files. You would only use shared log files if you do not want to create tables in the tempdb, you have a large number of concurrent sessions, and each session connects using an individual DBMS account. Either configuration option is acceptable for the workspace, but if you choose to store the log tables in the user schema (shared log files), instead of the tempdb (session-based), be sure to give CREATE TABLE privileges to each user accessing the tables.
Settings to control storage
Log file options are set using specific parameters in the SDE_server_config and SDE_dbtune tables.
For session-based log files, the DBTUNE SESSION_TEMP_TABLE parameter must be set to 1 (true) to allow the session-based log file table to be created in tempdb. For shared log files, changing the SESSION_TEMP_TABLE parameter to 0 (false) will create the SDE_LOGFILES, SDE_LOGFILE_DATA, and SDE_SESSION<SDE_ID> tables in the connecting user's schema; hence, the user requires CREATE TABLE permission.
Parameters in these tables are altered using the sdeconfig and sdedbtune commands, respectively. In SQL Server, the table created in tempdb is in the format ##SDE_SESSION<SDE_ID>. This table is truncated when the connecting application deletes its log files, and the table is dropped when the session disconnects. When using the default setting, users do not require CREATE TABLE permission in the database for the session table to be created in tempdb.