write data to influxdb2 is very fast, but read too slow until the influxd.exe crashed. i just read limit 100 data from my meansure,why? how can i do next
Short answer, influxdb3 was created partly to solve the challenges with querying data that is faced with v2.
Influxdb 3 is hopefully just around the corner now.
If you have a specific question with why a query is slow or using a lot of memory, ask away.
the problem is with the clients, I run the same query with curl, with the python cli, python requests, python sys, python subprocess. With curl its almost instant, with the python cli takes like 20 seconds, and with the others it takes like 8 seconds, Im requesting 66000 points.