New version 1.27v

This time new features related release:

1. Voting questionary module
   1. Windows for managing votes
   2. Widget for receiving user votes
   3. Option to configure voting
      1. Voting placement in window
         1. Right middle
         2. Left middle
         3. Bottom right
         4. Bottom left
      2. URL address on which particualar question should shown
   4. Tracking should be done by IP, one voting by one IP
   5. User should be able to expand and collapse box from widget
2. Three new positions for live helper chat main widget
   1. Right middle
   2. Bottom left
   3. Left middle

Feel free to report any issues. Demo also was updated. So we are going to kill all commercial projects peace by peace and make one of the best Live Support available for free.

Performance testing

I thought it would be interesting to see some performance testing. This time we simulate 1000 request with 5 concurent connections.

[demo]# ab -c 5 -n 1000 http://demo.livehelperchat.com/index.php/chat/syncuser/6/22/1e16f65d63f270401f90082a6fac9f3200ddab5d
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 demo.livehelperchat.com (be patient)
Completed 100 requests
Completed 200 requests
Completed 300 requests
Completed 400 requests
Completed 500 requests
Completed 600 requests
Completed 700 requests
Completed 800 requests
Completed 900 requests
Completed 1000 requests
Finished 1000 requests

Server Software:        nginx
Server Hostname:        demo.livehelperchat.com
Server Port:            80

Document Path:          /index.php/chat/syncuser/6/22/1e16f65d63f270401f90082a6fac9f3200ddab5d
Document Length:        103 bytes

Concurrency Level:      5
Time taken for tests:   5.349 seconds
Complete requests:      1000
Failed requests:        0
Write errors:           0
Total transferred:      462000 bytes
HTML transferred:       103000 bytes
Requests per second:    186.94 [#/sec] (mean)
Time per request:       26.746 [ms] (mean)
Time per request:       5.349 [ms] (mean, across all concurrent requests)
Transfer rate:          84.34 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        0    0   0.0      0       0
Processing:    15   27  17.0     24     235
Waiting:       15   27  17.0     24     235
Total:         15   27  17.0     24     235

Percentage of the requests served within a certain time (ms)
  50%     24
  66%     25
  75%     27
  80%     28
  90%     35
  95%     41
  98%     52
  99%     73
 100%    235 (longest request)

As you see application can handle about 180 requests per second. Having in mind that this request during chat is send every 3.5 seconds. We can support upto 600 chatting users at the same time if my calculations are correct :) (180*3.5 = 630)

New version 1.26v

Small release compared to previous one, but it does one amazing thing. Now all messages from user or operators will be checked using same query. Last message ID algorithm for user was implemented. I think it's one of the last performance related part. Futher updates will include more features than refactoring. We now have really nice live support engine.

Resume:

• Removed status column from messages table, not needed anymore.
• Same check messages algorithm for admin and user.
• Only one index is needed now for messages table. Improves write operations and eliminates update in user sync call.

execute doc/update_db/update_17.sql and follow standard upgrade instructions.

New version 1.25v

Finally released new version. This version brings a lot of improvements. This release brings whole bunch of changes, most important is the performance ones, I have spend a lot of time optimizing every single query, and limiting requests number to minimum. There is few things I still would like to change, but for the moment it will be just fine. So now every single query is using index.

Read full post for changelog

New version 1.24v

Enchancements:
1. Remember me functionality
2. How many pages user have visited functionality
3. First time user visit tracking

execute doc/update_db/update_15.sql

and follow standard update instructions

P.s Demo also was updated,