Have a simple "Dealer Locator Application" that I need in an ASP.NET application.

I have a SQL server with 1.3 Million Dealers with exact street addresses.

From ASP.NET page I want the user to type in their address...

100 S. Kentucky Ave Lakeland, FL 33801

From this we look into database for precise locations that match a two mile radius.

I would like to display a map on the screen, but need a list of matches to be displayed. Would be nice to have both!

We will pay for this application.

The application would be very similar to
http://demo.mappoint.net/fourthcoffee/locator.aspx

The problem we ran into with MAPPOINT.NET is...
A. Only has ability for 50,000 records (we need 1.3 million to start)
B. We could not get the 50,000 records to upload because the site crapped out everytime we used their browser upload.

rsell@4kicks.com
(863) 409-8236

Thanks

Ron Sell

Ron,

How about working MP in a different fashion! Rather than load ALL your Dealers into one MP session, why not try the following:

User enters address
You verify address and obtain long/lat of users address
You interogate your database for all dealers whose long/lat fall within a set range of users long/lat

You then only populate MP with the dealers that fall close to the user.


Regards,
Andy Yule
Revival Consultants Ltd

PS: I am a database consultant, if I can assist you further then please email me at Andy@Revival.uk.com

You have mail.

no i dont!

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!)