Step 2.7. Do advanced Logging Configuration
The Advanced tab in the data log's Table Properties dialog box enables you to:
- Disable logging actions for the table that you are configuring.
- Override the queue size that is specified in the Database Logger's Logging Properties dialog box.
- Select and control bulk insertion for Microsoft SQL Server or MSDE.
Select the Advanced tab in the data log's Table Properties dialog box.
Configuration options are as follows.
1 | Disable logging actions |
2 | Write a queue size/Use default |
3 | Use bulk insertion (Microsoft SQL Server and MSDE only) |
1 | Disable logging actions |
Select whether or not to log data to the table.
Do one of the following in the Disable logging actions checkbox.
Option | Description |
---|---|
Check | Do not log data to the selected table. |
Clear | Log to the selected table when the CIMPLICITY project is running. |
2 | Write a queue size/Use default |
Choose one of the following.
Option | Description |
---|---|
Use default | Check ??to use the universal size specified on the Parameters tab in the Database Logger's Logging Properties dialog box. |
Write queue size field |
|
3 | Use bulk insertion (Microsoft SQL Server and MSDE only) |
Use bulk insertion enables you to take advantage of the Database Logger's bulk insertion capability (Microsoft SQL Server or MSDE only).
- Check Use bulk insertion.
- Select the Maximum number of insertions that your system can handle.
- Select the interval between insertions in the Bulk insertion rate field.
The Database Logger will be triggered to insert records, based on whichever specification occurs first.
Example
You specify the:
Maximum number of insertions | = | 1000 |
Bulk insertion rate | = | 60 seconds |
As a result:
If the Database Logger: | Then the Database Logger: |
---|---|
Collects 1000 records within 60 seconds. | Inserts the records into the log. |
Does not collect 1000 records within 60 seconds. | Inserts whatever records have been collected. |