Last post Oct 15, 2012 04:03 PM by N_EvilScott
Oct 11, 2012 05:22 PM|armendderguti|LINK
Hi to all
I am going to develop a GPS tracking system which basically receives data from GPS device via GPRS store them in database show them for the real time monitoring and generate the reports.
What I need now is some advice in:
1. The data are transmited via GPRS connection over TCP. There are over 1000 units that sends data once per second. What is the best way to handle those data (receive, phrase, store in SQL, and show them in real time)?
(really need clear advice here!)
2. Can this system be done with Web Forms, Ajax, and SQL 2008 R2? If not what is proposed?
Thank you in advance
Oct 11, 2012 06:59 PM|N_EvilScott|LINK
The best thing you can do since its just regular packets coming over TCP is use as little overhead as possible. A Windows Service lends itself completely to this, and you can use the TcpListener object in the System.Net.Sockets namespace to capture all the
The windows service will be able to handle anything you want extremely fast.
After your backend is completed with that, you can create your front end with whatever tech you want.
1) Best way is to use the TcpListener and capture the data using a Windows Service
2) Capturing cannot be done via Ajax or Web Forms, but you can use the Windows Service to store information into SQL Server or some type of intermediate respository for viewing. You can VIEW the data with any standard web tech you want, but capturing will
require some low level code like Sockets and the TcpListener in order to get the quality you want.
Oct 12, 2012 04:18 PM|armendderguti|LINK
Oct 12, 2012 04:27 PM|N_EvilScott|LINK
Having the windows service communicate directly with the viewing mechanism generally isn't supported and you would need to use some type of interop in order to make it work anyway. Not only is it harder to do, but it can also hinder the service performance.
Much easier to just let the service collect info and dump it into a database or some other medium.
In my experience an sql database works perfect for this. That way you have the service operating normally and just inserting data to the database, and the database is taking all the pain of having to read and write at the same time from the View and from
The most simple way to display the data that refreshes every second is going to be using AJAX. It's very light and requires little effort.
There are essentially two common ways to set that up:
1) Use an <asp:Timer> ajax control and have it Tick every second and query the data and return it to the controls inside of an update panel.
Oct 13, 2012 11:40 AM|armendderguti|LINK
Oct 15, 2012 04:03 PM|N_EvilScott|LINK