Install Openfire with Mssql

 

GO to openfire Website

 

Download openfire for Windows OS

 

 

Select Language

 

Select Your DB Server

 

setting Dabase

 

Setting Profile

 

setting Admin Account

Finally You can login 

asdf

Query time Count

you can fine result millisecond

DECLARE @start_time DATETIME, @end_time DATETIME
SET @start_time = CURRENT_TIMESTAMP;


[your Query here]


SET @end_time = CURRENT_TIMESTAMP
SELECT DATEDIFF(ms, @start_time, @end_time),DATEDIFF(ms, @start_time, @end_time)/1000;

Oracle backup exp

exp system/oracle file=/backup/export/test05.dmp owner=(scott, hr)

Oracle import dmp file

Step by Step


if not exist
1. create user {user_id} identified by {password}

2. GRANT CONNECT, DBA, RESOURCE TO {user_id};

$ imp {user_id}/{password} file={filename}.dmp ignore=y full=y

wow very Easy~

Apache Benchmark

[root@dev bin]# pwd

/usr/bin

[root@dev bin]# ab -n 500 -c 20 http://{testURL}

설명 : ab –n Request개수(500) –c 동시접속자 URL (API)

 

== 결과값 ==

 

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/

Licensed to The Apache Software Foundation, http://www.apache.org/

 

Benchmarking 203.233.82.229 (be patient)

Completed 100 requests

Completed 200 requests

Completed 300 requests

Completed 400 requests

Completed 500 requests

Finished 500 requests

Server Software:        Apache/2.2.21

Server Hostname:        203.233.82.229

Server Port:            80

Document Path:          //account/view/terms

Document Length:        4593 bytes

 

Concurrency Level:      20 (동시 접속자)

Time taken for tests:   0.513 seconds (총 소요시간)

Complete requests:      500

Failed requests:        0

Write errors:           0

Total transferred:      2511500 bytes

HTML transferred:       2296500 bytes

Requests per second:    975.44 [#/sec] (mean)

Time per request:       20.504 [ms] (mean)

Time per request:       1.025 [ms] (mean, across all concurrent requests)

Transfer rate:          4784.80 [Kbytes/sec] received

 

Connection Times (ms)

              min  mean[+/-sd] median   max

Connect:        5    6   0.8      6       9

Processing:     8   14   8.3     11     124

Waiting:        7   14   8.3     11     123

Total:         13   20   8.6     17     131

 

Percentage of the requests served within a certain time (ms)

  50%     17

  66%     19

  75%     21

  80%     22

  90%     30

  95%     34

  98%     45

  99%     55

100%    131 (longest request)