Joined: 12/03/2010 08:03:04
I am using the SQL datasource to receive status from devices not currently compatible with Mango.
Each time the SQL table is read, Mango gets all records again (since I am using no where condition).
This of course presents a few issues, mainly for raising alarms and state detection events.
I can solve this in a couple of ways (stored procedure, TOP clause, etc), but I would like to hear from the Mango developers how would they set up and use the SQL DS.