Tag: optimization

Ender 5 Plus and the lit Lightbox (#E21F1)

Fiat Lux!

LED panel brackets are installed, and so are three “45W” panels that currently max out at 135W with the supplied AC drivers. I’m likely gonna move them to a dimmable solution (a DC-DC converter with external adjustment pot…), but for testing purposes that’s just fine.

Here’s a small print (30cm x 6cm x 2cm) with single-walled towers on each side, made from matte black PLA (Sunlu), still sticking to the black Ender glass printing bed. Clearly this needs a bit more optimization in that all black parts around it could use a more reflective surface covering to brighten up the scene. […]

20th August 2023 7th July 2024 By Bzzz In No Comment

MariaDB/SQL query gotcha and optimized solution (#E19)

Haven’t had a general advice post for a while, have we.

My small fleet of ESP32 boards across the apartment is still gathering information for the AVM Fritz DECT 301 radiator control units that just started the heating season. While their queries are really simple, quick and fully automated, I also have an HighCharts overview plot of all data with user-defined query depth, usually 300 minutes / 5 hours, but I think there’s no arbitrary limit to it. One could plot all 2 million rows of data…but I’m not gonna try.

Anyway, I recently noticed query times went up significantly, and the whole thing never was blazing fast in the first place. […]

30th October 2022 7th July 2024 By Bzzz In No Comment