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: [email protected] 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 [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
