# Multi filter : one with list of ids and second is geo contains

**URL:** https://discuss.aerospike.com/t/multi-filter-one-with-list-of-ids-and-second-is-geo-contains/4893
**Category:** General Discussion
**Created:** [January 29, 2018, 8:13am UTC](https://discuss.aerospike.com/t/multi-filter-one-with-list-of-ids-and-second-is-geo-contains/4893 "2018-01-29T08:13:58Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Ankit\_Goyal](https://avatars.discourse-cdn.com/v4/letter/a/b2d939/32.png) [@Ankit\_Goyal](https://discuss.aerospike.com/u/Ankit_Goyal)
#### Post date: [January 29, 2018, 8:13am UTC](https://discuss.aerospike.com/t/multi-filter-one-with-list-of-ids-and-second-is-geo-contains/4893/1 "2018-01-29T08:13:58Z")

</div>

We are using Aerospike’s query feature with geo point in a polygon filter. WE have created GEO2DSPHERE secondary index on the bin, but we see that it is taking time. Currenty the record in that set is around 9 million and might increase so we thought if we can increase the performance by sending primary ids in query so that geo search happens on matched records only instead of 9 million.

Please let me know if this is possible and how can we achieve that or is there any other way to increase the performance .

---

<div class="post-metadata">

### Author: ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)
#### Post date: [January 30, 2018, 1:06am UTC](https://discuss.aerospike.com/t/multi-filter-one-with-list-of-ids-and-second-is-geo-contains/4893/2 "2018-01-30T01:06:25Z")

</div>

Can you provide information about the hardware you’re running on (or if it’s something like Amazon EC2, the instance type)? Please add information on DRAM, CPU (cat /proc/cpuinfo if you don’t know the type and number of cores), SSDs (if you’re using those). How many nodes in your cluster?

The other thing would be to attach your aerospike.conf file to show the config parameters.
