search

eigenein / my-iot-rs

Yet another home automation (alpha)
https://eigenein.github.io/my-iot-rs/html
MIT License
32 stars 5 forks source link

[Core] Slow database query(ies) #146

Closed eigenein closed 3 years ago

eigenein commented 3 years ago 
Sep 20 12:27:10 my-iot my-iot[28648]: [WARN] (10) : SELECT timestamp, value FROM …; rows: 242, elapsed: 4.830s
Sep 20 12:27:10 my-iot my-iot[28648]: SELECT
Sep 20 12:27:10 my-iot my-iot[28648]:   timestamp,
Sep 20 12:27:10 my-iot my-iot[28648]:   value
Sep 20 12:27:10 my-iot my-iot[28648]: FROM
Sep 20 12:27:10 my-iot my-iot[28648]:   readings
Sep 20 12:27:10 my-iot my-iot[28648]: WHERE
Sep 20 12:27:10 my-iot my-iot[28648]:   sensor_fk = ?
Sep 20 12:27:10 my-iot my-iot[28648]:   AND timestamp >= ?
Sep 20 12:27:10 my-iot my-iot[28648]: ORDER BY
Sep 20 12:27:10 my-iot my-iot[28648]:   timestamp
Sep 21 21:00:02 my-iot my-iot[30188]: [WARN] my_iot::core::db::tasks: Upserted in 3.0s > 1.0s.
Sep 21 21:00:05 my-iot my-iot[30188]: [WARN] my_iot::core::db::tasks: Upserted in 1.3s > 1.0s.
Sep 21 21:00:12 my-iot my-iot[30188]: [WARN] my_iot::core::db::tasks: Upserted in 1.0s > 1.0s.
eigenein commented 3 years ago

Closing in favour of #143