timesten performance with tptbm

15 Dec

1. setup env & create DSN
[root@test ~]# cd /opt/TimesTen/tt70/demo/
[root@test demo]# sh ttdemoenv.sh
LD_LIBRARY_PATH set to /opt/TimesTen/tt70/lib:/u01/app/oracle/product/11.1.0/db_1/lib:/lib:/usr/lib
ANT_HOME set to /opt/TimesTen/tt70/3rdparty/ant
PATH set to /opt/TimesTen/tt70/bin:/opt/TimesTen/tt70/demo/performance:/opt/TimesTen/tt70/demo/ttclasses:/opt/TimesTen/tt70/demo/xla:/opt/TimesTen/tt70/demo/xla/xlaPersistent:/opt/TimesTen/tt70/demo/tutorial/java:/opt/TimesTen/tt70/3rdparty/ant/bin:/u01/app/oracle/product/11.1.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
CLASSPATH set to /opt/TimesTen/tt70/lib/classes14.jar:/opt/TimesTen/tt70/lib/timestenjmsxla.jar:/opt/TimesTen/tt70/3rdparty/jms1.1/lib/jms.jar:/opt/TimesTen/tt70/demo:/opt/TimesTen/tt70/demo/tutorial/java:.:/u01/app/oracle/product/11.1.0/db_1/JRE:/u01/app/oracle/product/11.1.0/db_1/jlib:/u01/app/oracle/product/11.1.0/db_1/rdbms/jlib
NOTE: The demos use system DSNs defined in
/var/TimesTen/sys.odbc.ini
To use your own DSNs, they must be defined in ~/.odbc.ini, or
you may set the environment variable ODBCINI to point to
the correct file.

2. install tools tptbm
[root@test ~]# cd /opt/TimesTen/tt70/demo/performance/
[root@test performance]# make -f Makefile tptbm
gcc -Os -finline-functions -I/opt/TimesTen/tt70/include -I/opt/TimesTen/tt70/demo/common -I/opt/TimesTen/tt70/include/ttclasses -o tptbm.o -c tptbm.c
gcc -Os -finline-functions -I/opt/TimesTen/tt70/include -I/opt/TimesTen/tt70/demo/common -I/opt/TimesTen/tt70/include/ttclasses -o utils.o -c /opt/TimesTen/tt70/demo/common/utils.c
gcc -Os -finline-functions -I/opt/TimesTen/tt70/include -I/opt/TimesTen/tt70/demo/common -I/opt/TimesTen/tt70/include/ttclasses -o ttgetopt.o -c /opt/TimesTen/tt70/demo/common/ttgetopt.c
gcc -o tptbm tptbm.o utils.o ttgetopt.o -L/opt/TimesTen/tt70/lib -Wl,-rpath,/opt/TimesTen/tt70/lib -ltten -lm

3. test timesten performance
a. test 1
[root@test performance]# ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert, 0% delete

Elapsed time: 1.3 seconds
Transaction rate: 31570.6 transactions/second

b. test 2
[root@test performance]# ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert, 0% delete

Elapsed time: 312.0 msec
Transaction rate: 128205.1 transactions/second

c. test 3
[root@test performance]# ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert, 0% delete

Elapsed time: 1.2 seconds
Transaction rate: 33726.8 transactions/second

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: