I has a list of assets (hardware) which report to a database whenever something changes
Currently i poll the database every 20 seconds to get updates
this worked fine on small volumes of hardware and connected browsers
However, now we are into thousands of hardware and users connecting to with browsers, the database is being hit very hard every 20 secs by each individual browser for data
I was thinking of moving to push instead of poll
I.e. if a certain table gets a new record, then push this message to all connected browsers that are currently looking at this unit
The browsers will be modern, but not just chrome or firefox,
also, users may login on their smart phone/ tablet
is PUSH a possible option for me? and how would you suggest I get started
I looked into signal R a bit, but there are too many unknowns
heres some info on the platform:
SQL server 2014 enterprise,
The data first gets pushed through a c# console app for processing before being inserted into DB, not sure if this can or should be part of process
500 Points go to someone who's been there and done that.
Please help me get started on the right track including some personal experience of you doing something similar.
Any info about supported browsers and light weightness etc will be much appreciated