Is there any possibility of improvement in speed ?

[happytm]

I have been testing your library and it is working fine.

I have a project that uses your library with my other favorite libraries to bring nice graphs on web interface with help of uPlot based on select queries for LittleDB.

My sketch is at: https://github.com/happytm/BatteryNode/blob/master/examples/ProbeRequestGateway_ESP32.ino

But as database grows it becomes too slow to show graph on web page.

I also tried other sqlite library at: https://github.com/siara-cc/esp32_arduino_sqlite3_lib for database which produces very fast query results but so far it has been hard to implement it with uPlot graphs. The test sketch I used for that library is at: https://github.com/happytm/BatteryNode/blob/master/test/SQLite3.ino

So my question was is it possible to improve speed for the queries little bit like the other library ?

Thanks.

[pouriamoosavi]

Hi Sorry for late answer.

Honestly I don't know any way to improve the performance. I'm not an expert in these kind of things, But I sure welcome any idea about how it is possible to increase the speed. So if you know any way please let me know and I try to implement it.

Best wishes.