Slow response time when data is a string

InfluxDB 2
1

I have a measurement with 255 timeseries and each of them contains a long string. When I run a simple query like this:

SELECT “3.V”,“3.Q” FROM data WHERE deviceId = ‘5’ and iobjectId = ‘3’ and time >= 1587810594000000000 and time < 1591083160000000000

It takes around 4 seconds to response. Is there any way to reduce the response time?

2

Hello @Ane,
Welcome!
How long are we talking? Can you please provide a length? Are these strings always in tags?
Thanks.

3

Hello Anaisdg,

They are around 230.000 characters strings and they are always saved as tags.

If you need anything else just tell me and I will answer you as soon as possible.