Looking at the Distance Calculator source that comes with MapBasic 8.5, I notice that the Distance Calculator is merely a wrapper around a single call to a single statement you could type into the MapBasic window. Thus, only a future version of MapInfo Pro can add any significant optimization to the process, if at all.
A call to "Set Table FastEdit On", as suggested by Peter, might help a little, but you're creating an O(N) optimization in an operation that's O(N^2) at best (and I fear much worse with polylines and region objects). The underlying command allows you to specify minimum and maximum distance criteria (I hope that means MapInfo uses the tables' spatial indexes), but the criteria don't appear in the Distance Calculator dialog. Spencer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evan MacDougall Sent: Thursday, October 12, 2006 12:03 PM To: mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SV: Distance calc mbx I have the same sluggishness problems with the Distance Calculator. Just running 20 or 50 or even 100 records takes way too long, IMO. Why should it take 10-20 minutes to do 100-200 records? Seems like it should work a lot quicker. -Evan MacDougall GIS Supervisor "Gentlemen, we may not make history tomorrow, but we shall certainly change the geography." -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Watertech - Jacob K. Jørgensen Sent: Wednesday, October 11, 2006 11:34 PM To: Hankins, Michael D.; mapinfo-l@lists.directionsmag.com Subject: [MI-L] SV: Distance calc mbx Hi Mike, You could insert a Commit statement for every 1.000 - 10.000 points in order to reduce the size of the temporary tables. You could also run the command with RamDisk (www.cenatek.com) as temporary drive to reduce the disk activity. And finally you could save the results in an array and only save on disk for every 1.000-10.000 points - also to reduce the disk activity. Best regards Jacob K. Jørgensen Engineer, M.SC. in GeoInformatics __________________________________________ Watertech Soendergade 53 DK-8000 Aarhus C Phone: +45 8732 2020 Direct phone: +45 8732 2078 Fax: +45 8732 2021 [EMAIL PROTECTED] www.watertech.dk -----Oprindelig meddelelse----- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af Hankins, Michael D. Sendt: 11. oktober 2006 16:11 Til: mapinfo-l@lists.directionsmag.com Emne: Distance calc mbx Is there a way to speed up the distance calculator mbx. Have 225,000 points to calculate distance. Been running 20 hours and only 30% completed. I have a good computer and no other programs running. Suggestions??? Mike Hankins COUNTRY Insurance & Financial Services _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l