Web Services Performance

Andrew Pham

Hello, I'm developed the Point of Sales (POS) application in Windows and iPad (iOS devices) app using local database such as MSSQL Server Express and Sqlite3. These applications work great and FAST in local network environment. For multi stations I used MSSSQL network server (TCP open port 1433). For SQLite system, I've wrote a complete WCF server/client then hosted on local network. Again, the systems work great and FAST. Now I want explore Web base application which mean that I must hosting web services on the WWW or Cloud services.

So, my question is what web service protocol should I use to maintaining the satisfactory POS performance (the applications still have run locally as native app). I have looks in to JSON, REST protocol but not sure will give the performance that I need because in POS world it is requires that fast and a lot database records to SELECT(GET), UPDATE(POST) and INSERT(PUT) in real-time or close manner.

I know that I can't get a real-time performance on web services but if I can get 80% plus performance that worth shooting for. Thanks...

Visit our website: ht

Visit our website: http://www.yesmua.com

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Andrew Pham13y ago
In my original post stated that I have a WCF client/server self host. I found that WCF is now support RESTFul with JSON data. Can I continue as RESTFul protocol to my current WCF dev. Is there any bottleneck to WCF services? Should I start new platform?
Andrew Pham13y ago
All my database tables are structured reflection to C# Class object below:

class Employee
{
        string Name {get;set;}
        string Address{get;set;}
        string SSN{get;set;}
        .
        .
        .
}

I probably serialize to JSON object then pass in service call. That should not be any bottleneck. I just want send raw data no overhead wrapper. What platform should I use.

Note: Some of my table contain a lot columns (100 columns) in simple data: string, int, datetime, bool.   No database relation or constrain.
Amit Choudhary13y ago
It's all about the performance vs scalability. for e.g. your load test your service and see if there's any bottleneck in your code that causing a slow down. Optimize that, once everything is optimized for performance then you should go for scalability. Means rely on your hardware to enhance the throughput. Use mirroring, CDNs for load and performance optimization when your webservice is ready to go alive on world wide web.