I'm going to log the consumption (water, electricity, gas, ect) for plenty of devices (take 400 devices which log every hour and we need to keep the data at least 2 or 3 years) .
Now i was wondering if i can better put them in 1 table with the following colums:
Type: Water, Electricity or Gas
Device: Which device we are logging
Value: The actual value
Date: date when the record was logged
Or can i better create a table for every device with only 2 column (Value and Date).
Because when i need the data for reporting, i never going to need all the devices (report we want to make are 32 devices).
I can make the Type and Device column indexed, but performance wise isn't it better to read only the tables i need?
Or is it more difficult to read multiple tables at the same time?
Thanks at advance!