title: Large amount of static values in linked selects! - ASP.NET MVC
body: <p>I have a conceptual problem. </p>
  
  <p>For an ASP.NET MVC / C# website (although the exact technology may not be that important) I have 2 linked drop downs (html select) with Countries and Cities of a continent. </p>
  
  <p>These are currently kept in 2 database tables and as you imagine the Cities table has round 10 000 records. </p>
  
  <p>The current functionality is:
  - initially the country select is populated. 
  - the user selects a country, an ajax request goes to the server, retrieves the cities for that country_id and populates the second (cities) select. </p>
  
  <p>Sometimes it gets a bit slow as you might imagine, and since these are in the end static values (the lists will not change) what will be the best way to treat this situation?   </p>