Posts

Showing posts from September, 2013

Install Openfire with Mssql

Image
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) Tim…