[v3] InfluxDB 3.5 performance seems worse than InfluxDB 1.7 for `show tag values`

he performance of InfluxDB 3.5 seems to be worse than that of InfluxDB 1.7. For example:

SHOW TAG VALUES FROM "metric_name" WITH KEY =~ /^tag_key$/ WHERE time > now() - 3d

If we use the DVC cache, it's equivalent to storing the dimensions in memory, which can lead to memory explosion issues.

Start by reproducing the reported SHOW TAG VALUES query against InfluxDB 3.5 and 1.7 using the three-day time filter and the DVC cache context described in the issue. Compare the results and resource use; done means the performance difference is characterized and the cause or a focused change is identified.

Written by the indexing model from the issue text.