I really interested in this project, I bet You know how much cost of sql server, and it can be migrate to redis (thanks antirez). I really don’t know if my way is accepted by the creator itself or by community, but in my opinion, it really solve all my problem.
So, the story begin with the old project itself, I can’t give you the address, but I can give You the screenshoot (I can give You real demo if only we meet one by one, thanks). This is the screenshoot of the old application.
As You can see in the bottom, it need 2.2 seconds to load data from database, and when I do test using apache bench, here is the result (sorry I can’t get the screenshoot of the old one, the project is shutdown now, I can only give you a text result 😦 )
root@ubuntu13:/var/www/campur/dokumentasi_infoguru# ab -c 10 -n 10 "http://**************" 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 22.214.171.124 (be patient).....done Server Software: Apache/2.2.11 Server Hostname: 126.96.36.199 Server Port: 8081 Document Path: *************************** Document Length: 20244 bytes Concurrency Level: 10 Time taken for tests: 6.280 seconds Complete requests: 10 Failed requests: 9 (Connect: 0, Receive: 0, Length: 9, Exceptions: 0) Write errors: 0 Total transferred: 206188 bytes HTML transferred: 202458 bytes Requests per second: 1.59 [#/sec] (mean) Time per request: 6279.519 [ms] (mean) Time per request: 627.952 [ms] (mean, across all concurrent requests) Transfer rate: 32.07 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 2 3 0.9 3 4 Processing: 5808 6186 140.8 6234 6277 Waiting: 3098 3574 178.4 3619 3716 Total: 5811 6189 140.8 6236 6279 Percentage of the requests served within a certain time (ms) 50% 6236 66% 6253 75% 6275 80% 6278 90% 6279 95% 6279 98% 6279 99% 6279 100% 6279 (longest request)
As You can see, it give 1.59 RPS
And this is the screenshoot of the new one. I use bootstrap v3, so it really mobile friendly. Here is the screenshoot.
And here is the apache bench screenshoot (with the same data and same result) :
Yeah, that’s the most awesome experience when I work in my current company.