Hardware and Database Logger Performance

On a 400 MHz Pentium II with 200 MB memory

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.

Bulk Insertion Peak Performance

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
Important: (For SQL Server) insert triggers fire only if bulk insertion is disabled.