com2000-2.jpg (55204 bytes)                             

            logo_ch2.jpg (9721 bytes)

NETWORK INFRASTRUCTURE      .      NETWORKING SOLUTION    .   NETWORK HARDWARE    .  
NETWORK SOFTWARE    .       COMPUTER     .       SERVER     .      SQL DATABASE SYSTEM

　

 

rstlogo.gif (2645 bytes)

　

Performance

Database performance: (June 2001)

TYPE Single table “Select” querying
SQL SCRIPT “select * from Tbl_stock_in”
Measured time (1) 32 seconds for 96,000 rows of data
Measured time (2) 04:42 minutes for 1,850,000 rows of data

　

TYPE Two tables “Select” querying with “Join”
SQL SCRIPT 　
Measured time (1) 42 seconds for 94,000 rows of data
Measured time (2) 09:04 minutes for 1,960,000 rows of data

　

Tested system: Rock Server RK-12S

CPU: Single processor at 1.2 GHz

Memory: 256MB

Storage: 20GB ATA-100

OS: Windows 2000 Server

DBMS: SQL Server 2000

　

　

　

[Home]  [Networking Solutions]  [Networking Hardware]  [Networking Software]  [Links]   [News]   [Support]

Last modified: 28/06/01