Products

Performance

SQLServer2008 Communication

Add array OPCItems as Advise from a OPC Client.
It is measured reading time from added OPCItems. Communication performance is defined as average time of ten times measurement.
This time means to read the value of a continuous area of the device.

PC specification

* You can scroll this table sideways.

OS	Windows 7 Professional 32bit OS
CPU	Intel(R) Core(TM) i7 CPU 870 @2.93GHz
Memory	3.00GB
OPC Server	DxpSERVER OPC Server Ver5.0.1.1
OPC Client	OPCClient sample VcSampleOpc(C++)
Cable	100BASE-TX cross cable connecting directly

OPC Server setting

* You can scroll this table sideways.

Protocol Timer Tick	10msec
Timer Tick for Async Update Mode	10msec
Multi Access Mode	Enable
Multi Access for Snyc Asnyc	Disabled
Async Update Mode	Disabled

ODBC setting

* You can scroll this table sideways.

Database	SQLServer2008
Table	field nums:101(int)
Data	33,000 records

Communication Performance

(sec)

* You can scroll this table sideways.

	1024	2048	4096	8192	16K	32K	64K	128K
Average	0.072	0.077	0.082	0.117	0.191	0.348	0.637	1.207
Max	0.073	0.077	0.083	0.119	0.194	0.369	0.654	1.220
Min	0.071	0.076	0.081	0.116	0.189	0.342	0.629	1.193

Results

It is possible to get max 4,000 points per sec.

Comment

*Graph displays average time of ten times measurement.(1point = 1record/field )
*In case of 8K points access , Read 4K points by using 2 fields.( 4K point per 1 field).
*The result only means our examination, it doesn't guarantee performance.
[Aug 2012]

Interface performance

Results of measurement of each interface(eg.sync /async /datachange event etc).(detail)