search

zieren / wasted-youth-tracker

Limit kids' time on their (Windows) PC and get a summary of the window titles.
GNU General Public License v3.0
5 stars 0 forks source link

Log DB query runtime #75

Closed zieren closed 2 years ago

zieren commented 2 years ago

It would be useful to know what queries cost in terms of runtime.

Simple approach: Use MeekroDB's success handler and output the runtime field to the log.

Even better would be to keep track of the running average runtime of queries, e.g. "reclassify" or "query time left per limit", in a table so we get proper stats.

zieren commented 2 years ago

There is no need to keep stats as the variance is low. Logging the query runtime and reporting request time on the client is sufficient.