I wrote a MapBasic program to find the minimum distance from the points of a table to the surrounding points in another table.
The program take a point (one at a time, and consectutively) in table one, and extracts the objects within 4 km of the point from the table2 into a temp table. The distance between the point and the temp table are calculated. The object with the shortest distance are selected, and the ID from the selected object are put back into an variable of the point in table one.
The program works very well at the begining. After processing to 4000 points, the speed for the program slow down significantly. When the process reach 10,000, the speed become so slow that I cannot finish the remaining processing. It take more than 24 hours to process 1000 cases compare with 20 minutes for the first 1000 cases, and the speed is continuously to decrease. The speed is reduce exponentially. As a result, I can't finish the whole process with 17,000 cases. I do not accumulate any value in my program, and can't find the reason for slowing down.
Do any one has similiar experience that can help me to solve the problem? Any idea that leads to the problem?
Raymond Li
-------------------------------------------------------------------------- Security Statement
The information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it.
Disclaimer
Any views expressed in this communication are those of the individual sender, except where the sender specifically states them to be the view of DOH. Except as required by law, DOH does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception, inference or interference. --------------------------------------------------------------------------
To unsubscribe, write to gislist-unsubscribe@geocomm.com ________________________________________________________________________ GeoCommunity GeoBids - less than $1 per day! Get Access to the latest GIS & Geospatial Industry RFPs and bids http://www.geobids.com
Online Archive of GISList (and numerous others) available at: http://spatialnews.geocomm.com/community/lists/
Setup a GeoCommunity Account and have access to the GISDataDepot DRG & DOQQ Catalog http://www.geocomm.com/login.php
|