MapForums
Community of VE/MapPoint Users and Developers
Improving the performance of generating pushpins Programmati
This is a discussion on Improving the performance of generating pushpins Programmati within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Hi everyone I already generated a table containing name,latitude,longitude of a big amount of points. the code i send here ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-17-2006
| |||
| |||
| Improving the performance of generating pushpins Programmati I already generated a table containing name,latitude,longitude of a big amount of points. the code i send here works, but it takes a lifetime to generate the pushpins in desired locations. can anyone please hint me on how to reduce the time for generating them? (it took almost 15 hours to generate about 2500 points while importing the same data in MapPoint got les than 1 min to show!) [C#] Code: // here my dataTable is generated
DataTable mydt = DBAccess.ProcessSpecialRoadPoints(itemChecked.ToString());
MapPoint.Map map =this.axMappointControl1.ActiveMap ;
[color=orange]foreach (DataRow drl in mydt.Rows)
{
MapPoint.Location location = map.GetLocation(Convert.ToDouble(drl["LATITUDE"]), Convert.ToDouble(drl["LONGITUDE"]), 1);
MapPoint.Pushpin pin = map.AddPushpin(location, NAME);
[/color]
}
KMB
__________________ KMB         |
|
05-19-2006
| |||
| |||
|
Hi, Its been a little while I did something in dotNet. But possible the iretation trough the database, also the convertion to double cost a lot of time. I assume you checked the loop already with the conversions, but without the calls to mappoint ? 15 hour seems to me very long for 2500 pushpins. Did you also try a test in a close loop without any conversion or collention to put 2500 pushpins on the map, eg with slight increments of lat/long to show them ?
__________________ rgds, Wilfried Mestdagh www.mestdagh.biz MapPoint coding demo Order MapPoint 2009 with Routing and User Tools Spreadsheet |
|
05-21-2006
| |||
| |||
|
Dear Wilfried thank you for your kind answer; actually there is no way I can bypass the conversion to doubles! but, thanks to you again, I could find my answer in this other post of yours! http://www.mp2kmag.com/mappoint/disc...ushpin+dataset
__________________ KMB |
 |
| Tags |
| generating, improving, performance, programmati, pushpins |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Improving On The MapPoint Geocoding Algorithm | Anonymous | MP2K Magazine Articles | 10 | 03-12-2005 02:22 PM |
| Visual Basic 6.0 generating a map based on access data | virgilar | MapPoint Web Service and Virtual Earth | 0 | 03-11-2005 08:27 AM |
| Generating Localized Maps | faddat | MapPoint 2006/2009 Discussion | 1 | 01-14-2005 02:11 PM |
| generating with/implementing a map in MapPoint 2004 | mohrm | MapPoint 2006/2009 Discussion | 0 | 09-21-2004 03:56 AM |
| Generating maps for a datapoint set | Anonymous | MapPoint 2006/2009 Discussion | 0 | 05-13-2003 07:56 AM |
All times are GMT -5. The time now is 01:38 PM.
