# Response time is slow for select queries

**URL:** <https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291>\
**Category:** Telegraf\
**Tags:** influxdb\
**Created:** [May 24, 2018, 7:49am UTC](https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291 "2018-05-24T07:49:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![prasannasatya](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@prasannasatya](https://community.influxdata.com/u/prasannasatya)\
**Post date:** [May 24, 2018, 7:49am UTC](https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291/1 "2018-05-24T07:49:42Z")

</div>

Hi,

We have a measurement with around 11 million points. If I run a select query like

“select field1,field2,field3 from sample where tagname = 1 order by time desc”

it takes around 2 minutes to get back the result. All the 11million points are collected and stored on a single day with a shard duration of 6h. So roughly around 2.5 million entries in each shard per day.

I’m using Influx 1.5.2 version with disk based caching enabled. Any suggestion on how we can improve the query response time?

I do not want to add a time filter (like time \> now() - 1h) as the users can run the query without the time filter as well.

---

<div class="post-metadata">

**Author:** ![prasannasatya](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@prasannasatya](https://community.influxdata.com/u/prasannasatya)\
**Post date:** [June 18, 2018, 9:18am UTC](https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291/2 "2018-06-18T09:18:12Z")

</div>

Can anyone pls help me with this issue…

---

<div class="post-metadata">

**Author:** ![katy](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/katy/32/855_2.png) [@katy](https://community.influxdata.com/u/katy)\
**Post date:** [June 18, 2018, 5:05pm UTC](https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291/3 "2018-06-18T17:05:55Z")

</div>

What is your series cardinality like?

---

<div class="post-metadata">

**Author:** ![prasannasatya](https://avatars.discourse-cdn.com/v4/letter/p/958977/32.png) [@prasannasatya](https://community.influxdata.com/u/prasannasatya)\
**Post date:** [June 22, 2018, 8:45am UTC](https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291/4 "2018-06-22T08:45:31Z")

</div>

Its around 11 million points…

---

<div class="post-metadata">

**Author:** ![noahcrowley](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/noahcrowley/32/818_2.png) [@noahcrowley](https://community.influxdata.com/u/noahcrowley)\
**Post date:** [June 22, 2018, 12:18pm UTC](https://community.influxdata.com/t/response-time-is-slow-for-select-queries/5291/5 "2018-06-22T12:18:31Z")

</div>

The number of points is not the same as series cardinality. You can read a bit more about [series cardinality in our documentation](https://docs.influxdata.com/influxdb/v1.5/concepts/glossary/#series-cardinality).