# Country –\> City form field query

**URL:** <https://community.triggre.com/t/country-city-form-field-query/118>\
**Category:** Support\
**Created:** [October 27, 2020, 9:46am UTC](https://community.triggre.com/t/country-city-form-field-query/118 "2020-10-27T09:46:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Unknown](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/unknown/32/31_2.png) [@Unknown](https://community.triggre.com/u/Unknown)\
**Post date:** [October 27, 2020, 9:46am UTC](https://community.triggre.com/t/country-city-form-field-query/118/1 "2020-10-27T09:46:00Z")

</div>

Best Community,

One of our applications we’ve built contains a CRM module.  
Within this module users can manage their customer relations, and therefore they need to insert their relations.  
Of course we also want to document the address of a specific relation, so they need to fill in the Country & Place (city/village).

Since there are millions of cities in the world, the ‘Cities’ table will be huge.  
We already did some testing after importing a lot of places, and we find out that it even takes up to 15 seconds sometimes to load all cities when opening a drop-down form field.  
This is not weird of course, since you are loading thousands of records, but it is not very user-friendly.

Therefore we were wondering if some of you have found a different (better) approach to this, so that users do not have to wait half a minute before they can select a city on a form.  
I suppose we are not the only one who will experience this issue, since address information is used in a lot of applications.

Let me know if you have a more user-friendly solution for this 😀

---

<div class="post-metadata">

**Author:** ![Triggre](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/triggre/32/14_2.png) [@Triggre](https://community.triggre.com/u/Triggre)\
**Post date:** [October 27, 2020, 9:46am UTC](https://community.triggre.com/t/country-city-form-field-query/118/2 "2020-10-27T09:46:21Z")

</div>

Hi,

The solution for this issue is to filter the selection as much as possible. So first selecting a country will help, since you can only show cities within that country. In the US you’d still have a lot of cities left, so an additional filter on State would help there as well.

Could that help solve this situation?

---

<div class="post-metadata">

**Author:** ![Unknown](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.triggre.com/unknown/32/31_2.png) [@Unknown](https://community.triggre.com/u/Unknown)\
**Post date:** [October 27, 2020, 9:46am UTC](https://community.triggre.com/t/country-city-form-field-query/118/3 "2020-10-27T09:46:44Z")

</div>

Thanks for your response!  
It seemed that through an import error we had some performance issues on our instance.

Currently it is working at the speed of light again 😀