Page 1 of 1

Shortlog interval Question

Posted: Sunday 01 November 2015 15:49
by rmtucker
Just wondering?
I have been using Domoticz for a few weeks now and have no complaints.
But i do have a question?
Would i be right in my assumption that Domoticz only records data once every 5mins?
So in simple terms i can throw as much data (temp + Energy etc) as i like but it will not record it all?

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 15:53
by SweetPants
Your assumptions are right

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 15:54
by gizmocuz
Correct

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 17:03
by gizmocuz
i have seen your question also in another post...

.... you can try beta #3532, there is a new option in the settings for the shortlog, the update interval.
But i would not advice to lower it, as i have no experience what the implications could be:
- larger database
- slower domoticz
- when settings to 1 minute, and you have set the short log to 7 days, that will be 10.080 values that are retreived when displaying a chart, and must be processed internally in domoticz
for each value there will also be overhead in the html/json

But if you would like to test it... please go ahead.

if it gets slow, you can always clear your shortlog, i would advise to do this at 00:05am in the morning

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 17:57
by rmtucker
gizmocuz

Thank you for your reply.
I am quite happy with the 5 minute interval.
From my past experience with pvoutput.org that is also 5 minute intervals,it gives more than adequate results.
It was just curiosity because i have seen the odd screenshots of domoticz which showed data at intervals less than 5 minutes.
I am a little reluctant to update from my v2.3475 as it is very stable and there seems to have been a bit of instability with the last few updates.

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 18:00
by gizmocuz
there is no issue with the latest beta (or stable) now

there was a problem before that caused the shortlog to be automatically set to 1 minute, and the database had no indexed and because of that, it became slow
not it has indexes, but i never tried it myself on my live system...

i would advise to upgrade to the latest beta now, before it gets instable, because i have some major changes planned (logging in UTC is one)

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 18:09
by rmtucker
Gizmocuz

On your advice I have took the plunge and updated to v2.3532.
Fingers crossed.
Thanks

Re: Shortlog interval Question

Posted: Sunday 01 November 2015 18:10
by gizmocuz
Let me know... but i think your fine with this update

Re: Shortlog interval Question

Posted: Sunday 07 February 2016 12:26
by ricard
Just in case someone is interested

I have successfully changed the log interval from 5 minutes to 1 minute by changing the iShortLogInterval in the SQLServer.cpp

And then rebuilding/re-making the code

viewtopic.php?f=4&t=10183&p=73855#p73855