SMS Voter for MS Smartphone released in new major version - 2.0
January 16, 2007 [MS Smartphone] | By Edward J. R.
We were reporting about this SMS voting program previously but now new version has just been released by an employee of Microsoft Australia:
So what's new?
- 10 active polls with their own score criteria
- Three vote types: First Vote Wins, Last Vote Wins, Allow Multiple Votes
- Prize Draws: selects a random vote by poll or score
- Much better User Interface giving a much more interactive/friendly experience.
- Multi threaded to allow messages to be processed in the background while querying results and updating poll properties in the foreground
- Much improved database performance!!
- With the SMS Voter database loaded with 30000 votes then performance for new votes ranges from 45 to 100 inserts (or updates) per second on a i-mate Smartflip and 60 and 150 per second on a i-mate Jasjam. This is way in excess of the number of SMS votes that a phone would receive from a network. (Btw, the reason for the variance is due to vote types processed, some requiring selects (to check for previous votes) before inserts or updates)
- Table structure very simple - 1 Table with 2 composite indexes.
- Query (select group by) performance is fine for polls up to around 8000 votes then it starts to get a little sluggish - but again this is way in excess of this applications typical usage scenario. Query performanance for polls with up to around 4000 votes is blindly quick:)
To learn more or to download this program in both versions - for MS Smartphone and Pocket PC phone, click here.
Post your comment (free registration is required to post, but if you register you can edit your posts later)

|
|