Hi, guysI'm trying to figure out a way of updating a lot of records, i'm building an application that polls network devices every minute, and stores the relevant data to a database. In doing so i have made a "RRD" (Round Robin Database) (every network device has 1440 records in a table. The 1440 records represent every minute of a day.)
The problem is that I have up to several thousand different network devices to poll. The polling is no problem, but the updating of the records in the database poses a problem as it takes way to long. Please if anyone have any ideas on how to deal with this, either another way of storing the data, or an efficient way of updating the records in the database.
I’m using Visual basic 2005 and SQL 7.0.
Thanks,
Martin