View Single Post

  #5 (permalink)  
Old 02-04-2003
David Kachuck David Kachuck is offline
Junior Member
Yellow Belt
 
Join Date: Jul 2002
Posts: 17
Send a message via AIM to David Kachuck
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)
Reply With Quote