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:
|
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:
|
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.