My team has the following issue. We currently have a relational database with around 40 million entries - they are all entries from tags (TagId, TagValue, TimeStamp). We decided to move to a TS database to improve performance as the numbers keep going up.
After importing the 40m values to Influx, we have tried the following query:
SELECT * FROM dump WHERE time > 'some_date' AND TagName = 'tag_name'
This query runs 3 times slower in InfluxDB than in SQL Server. I tried a lot of different queries, but all of them come slower in InfluxDB and I can’t figure out why. The database has a default retention policy.
The measurement has two fields - Int and Float and one tag - TagName.
The SQL Server and InfluxDB are running on the same hardware in the same network.
Any suggestions are welcome. Thank you.
EDIT: The data I am querying is for the last month.