SQL Server

For Database Logging Peaks at Around

On-node

265 writes per second (2 field writes)

Off-node

100 writes per second (2 field writes).

However, off-node is dependent on your network configuration as well.

Table Type

Write Definition

DATA

One point being logged.

If you have 20 points, you are doing 20 independent writes (when is configurable individually for each point). The size of each write (number of fields) depends on how many attributes you are logging.

Fields include:

1 for timestamp

1 for the point ID

Anything else you are logging (e.g., value, engineering units).

The more attributes you have, the slower the writes will be.

GROUP

Is based on your table's logging conditions. The number of points and the attributes being logged (configurable independently for each point) determine how big the writes will be (how many fields there will be).

Fields include:

1 for the timestamp

Anything else you are logging.

Example

If you are logging the value of two points, your group log table will have 3 fields, timestamp and two fields for the points' values.

CIMPLICITY Database
Logger using bulk insertion.

Avg.
bytes/write

Approx.
Writes/sec

Approx.
Total throughput/sec

On-node

28

900-1000

25-30Kb

Off-Node

28

700-800

20-25Kb

Database Logger configuration overview.