Forum Discussion
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...
"select ... where data>X and data<y and sensorid=z"How can I speed up things and make this more efficient?
Have you created a suitabel index for your query?
