SMS Voter 2.0 for the Smartphone and Pocket PC Phone Released

Happy New Year and if you took some time out then hope it was a good one!!

Well the SMS Voter app that I put together a year back still generates a lot of interest so I found some time over the holiday break to write V2 of the SMS Voting application. Lol, remind me not to do that again!!

It's much improved over version 1 and many thanks to Shane's feedback it's much friendly as well - ta Shane!!

So what's new?

1. 10 active polls with their own score criteria
2. Three vote types: First Vote Wins, Last Vote Wins, Allow Multiple Votes
3. Prize Draws: selects a random vote by poll or score
4. Much better User Interface giving a much more interactive/friendly experience.
5. Multi threaded to allow messages to be processed in the background while querying results and updating poll properties in the foreground
6. 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:)

Installation Locations

The Smartphone version is available from https://www.smartphone.net/software_detail.asp?id=2983.

Pocket PC Phone Edition version

• I want to do more testing of the Pocket PC version as I spotted a UI glitch today and I'm not sure if it's was a platform problem or an issue with the PPC version of the app.  Bar that I'll publish it to www.pocketgear.com by the end of the week.
• If you'd like to test out the Pocket PC Phone version then please drop me a note via my blog and I'll send you a link...

User Guide

The User Guide is available from https://blogs.msdn.com/dglover/pages/sms-voter-2-0-online-documention.aspx...

Cheers, Dave

Hmmm, me thinks time to replace my UPS, Bushfire causes massive blackouts, blimey!!

Comments

• Anonymous
  January 16, 2007
  myITforum Daily Newsletter Daily Newsletter January 16, 2007 The myITforum.com newsletter is delivered

• Anonymous
  January 16, 2007
  I've been using this application at a few presentations I've been giving as it's a great way to demonstrate

• Anonymous
  January 28, 2007
  I had a couple of requests for the source code for SMS Voter 2.0 and since it's all freeware and hopefully

• Anonymous
  March 27, 2007
  hi i'd like to use the software on my pocket pc. it's a dopod 818pro. can i have the link? thanks my email add is abazli@gmail.com

• Anonymous
  April 04, 2007
  For some reason it doesn't work on Sprint Moto Q.  All the text messages are truncated and only the first letter gets through. Felix1 [at] gmail [dot] com

• Anonymous
  August 19, 2007
  If you attended my Dynamic Data Controls session at TechEd then you'd have spotted the latest version

• Anonymous
  August 19, 2007
  If you attended my Dynamic Data Controls session at TechEd then you'd have spotted the latest version