Slow Table with lot of registers
Hello,
I have a database with a big table that I store sensor values, basically the structure is
ID, DataTime, SensorID, Value.
Each sensor sends data each minute, I have more than 100 sensors, so every day is a lot of records (more than 20.000.000 each month)…
2/3 months is not bad, but more than that is getting slow every time I want to do a graph, doing a
“select … where data>X and data<y and sensorid=z”
How can I speed up things and make this more efficient?
Thanks for any tip.
JS
Hello,I have a database with a big table that I store sensor values, basically the structure isID, DataTime, SensorID, Value.Each sensor sends data each minute, I have more than 100 sensors, so every day is a lot of records (more than 20.000.000 each month)…2/3 months is not bad, but more than that is getting slow every time I want to do a graph, doing a”select … where data>X and data<y and sensorid=z”How can I speed up things and make this more efficient?Thanks for any tip. JS Read More