| filter the db
I agree with Andy Yule that filtering the database and answering the query in 2 steps is a good solution. Let MapPoint do as little work as possible because its slow. If you have good addresses it shouldn't be necessary to go for lat/lon's though. Why not filter for all neighboring zip codes. Good to use index since db is not updated, right? Then let the map do only the work of displaying the results. To show a list you wouldn't even need a map.
I am also a database consultant. (My wife thinks I'm very smart!)
__________________
David Kachuck dk0146@netscape.net
Oracle Certified Professional Database Administrator (OCP)
MS Access Certified Expert (MAUS)
|