I have a conundrum,
I've developing a site that I want to have a auto complete field so that users can start typing their destination and the nearest matches appear, Using the Jquery UI auto complete function.
However I'm thinking that having the database being queried all the time will lead to this box being slow.
I have a table for insurance groups, domestic, world, world inc US etc
In the country table each country tuple is assigned the foreign key in the database of the region they belong too.
There are around 200 countries in the world, what would be the quickest more efficient way to develop this functionality in such a away that this search box is responsive.