How can impliment real time alarm in vehicle tracking

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

I'm developing GPS tracking system with ASP.Net MVC and SQL Server with DB-First. I have question about real time alarm

My application will should send alarm when the car enters or exists the geofence, or when speeding.

My scenario is when received data from GPS device At the same time i will compare with our data in database if car inter or out of geofence i will send SMS to central control

But i don't know its good idea? that i check and Processing that data when i i got data from 'GPS' device.
and another idea create the job in sql server and after some time check the that table insert by socket then send sms or mail,

What I have tried:

at now i developing real time alarm when the socket check data for insert in table
but if register many car in our system , i dont know that way its good or not
If you have better idea i will be glad if you can help me

Posted 8-Jan-20 2:19am

mohamad_ali

Updated 8-Jan-20 7:03am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2020-01-08T07:03:00

Solution 1

I think Nuclio will be of interest to you: serverless-frameworks~nuclio[^]
You will have to use .NET Core though and probably give up on SQL Server too ...

Posted 8-Jan-20 7:03am

RickZeeland

Comments

mohamad_ali 8-Jan-20 13:56pm

Thnx for your answer,
but i developing with mvc5,
i want another solution

RickZeeland 8-Jan-20 14:14pm

Well, as the saying goes "stick with what you know".
But that might not always be the best, I worked for years with SQL Server for instance, but would never choose it for realtime purposes.

mohamad_ali 8-Jan-20 14:27pm

Sql server is good solution If i will send alarms with delay time for example ever 30 second?According to this point i should process many gps data,

RickZeeland 8-Jan-20 14:44pm

30 seconds should be no problem for SQL Server, but it also depends on the volume of requests. Also running SQL Server on low-spec hardware is not a good idea. In the past we encountered problems with SQL Server, it could not cope with a high amount of requests, that's why we now use PostgreSQL which performs much better.