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
