polling a table in a DB

Question

3.00/5 (1 vote)

See more:

I have an application(a windows service) which listens to an incoming port and does some stuff and inserts a record in the DB and returns a byte stream to a socket. I need another service which polls the DB all the time and checks the flags in the record(last inserted record) and if a condition is met a specific task is performed by the service. I need advice regarding how to architect such kind of application.

Posted 30-Dec-12 19:18pm

Member 9716591

Add a Solution

Comments

Suvabrata Roy 31-Dec-12 1:31am

Few querys :

1. Return some byte stream (why need to return some stream)
2. How frequently a service consumer will call service (as you predict)
3. How frequently data would insert at you DB (as you predict)
4. How many concurrent users are their in both way (Put and Get)

Gordon Beeming 31-Dec-12 4:18am

You said that the polling service would look at the last inserted record, if you polling the service might not catch each record, are you aware of this. I'd suggest that if you need to capture each record add logic into your initial service that will do th polling services logic with each record after inserting it.

3 solutions

Solution 3

I think the timer elapsed event should do the trick.

Thanks for the quick advice.

Posted 30-Dec-12 19:51pm

Member 9716591

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)

Kiran Susarla · Accepted Answer · 2012-12-30T19:26:00

Instead of developing and deploying another service, in your current service you can add an timer.
Using the timer elapsed event you can poll the database on the periodic basis. You can start the timer on start and resume of the service and stop the timer on pause or stopping the service.
In the elapsed event, you can read the data from the database and perform the tasks that you need.

Christian Graus · Accepted Answer · 2012-12-30T19:27:00

Solution 2

You're just going to have a timer, and make a DB call to see if the condition is met. I'm not sure what you're looking for here. If you're doing inserts in to the DB, I would consider if it's possible to notice the change in your app, and not poll the DB constantly ( which is expensive ).

Posted 30-Dec-12 19:27pm

Christian Graus