Need to change data from "as is" to "speed per second"

[linuxgurugamer]

I have a fairly large database, with about 75 million rows in the history table. I have a number of items which collect data once every 300 seconds. This throws our graphs off, and I want to convert the items to a "speed per second", while preserving the history.

I need to update the history.value, trends.value_min, trends.value_avg, trends.value_max by dividing by the items.delay

I will be selecting the items by the description:

select itemid, delay from items where description like '%disk write%'

This select will return 20-30 items, and each item’s history will need to be updated with it’s respective items.delay

Has anyone done this yet? Is there a tool?

While I can write the code, I'd rather use an existing, debugged tool.

Thanks in advance.


JBB

[Yello]

Hi,
No tool that I'm aware of. As I think you already suspect, you're gonna have to write and test the code yourself.


Regards,
David