Pat, I expect consolidating the SLE will have little effect. The part of the SLE code that takes the largest proportion of the execution time are the queries on the database and the number times each is run. If for example there are 4 SLEs each with 10 getSqlVectors calls and say 6 reports in a skin then getSqlVectors will be called 240 times during a report cycle. If you refactor the SLEs such that there is only 1 with 40 getSqlVectors calls then there will still be 240 getSqlVectors calls per report cycle. If there was commonality between the getSqlVectors calls then consolidation might provide a tangible benefit but there is little little commonality between the getSqlVectors calls as they are structured now. The only ways I am aware of to reduce the overall execution time is to judiciously allocate reports and SLEs to skins (the limit being a day skin, a month skin, a year skin etc each with a single SLE) or refactor/rewrite the SLEs. I have been playing around here this arvo with a SLE that lazily provides a JSON vector, ie it is calculated when its needed and it whilst it appears to work I haven't benchmarked it yet nor have I properly tested it. I am hopeful though that it will provide significant efficiencies for the highcharts like SLEs.
Gary On Wednesday, 29 August 2018 21:24:08 UTC+10, Pat wrote: > > Gary, I noticed the SLE running multiple times and I figured it was > because it looks through each one every time. Does it make sense for me to > consolidate all of my Belchertown SLE into one function. And maybe even > consolidate all of the highcharts into one? Then instead of 16 runs it'll > only be 2... Well 4. > > On Wed, Aug 29, 2018, 7:19 AM gjr80 <gjrod...@gmail.com <javascript:>> > wrote: > >> And still on a 1 minute archive period? >> >> Gary >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/GSrKZEiPqsc/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
