This demo matches your city location from your IP address, then searches an external SQL 2005 database of 43,246 cities in US, UK, CA and AU.  The demo is hosted entirely on a single Windows 2008 Server Web Edition, with a SQL 2008 Express Edition which ultilizes only a single 2.0 Ghz CPU core, 1 GB Memory and a 7200 RPM Raid-1 drive. 

For each search requests, data access time from the SQL server is about 100 ms.  Web server processing, network transfer and browser rendering are totalling about 200 ms.

To simulate visitors from other cities, click on the 3 sample cities:
Wayne, PA  |  Fort Worth, TX  |  Mountain View, CA

The map setup is very simple.  A custom query can be defined as simple as "select * from cities", then our module will take care of all the IP matching, searching, distance calculations, filterings, location mapping and listing display.