RE: [MI-L] SV: Distance calc mbx
Which version of MapInfo are you using ? The Distance Calculator was improved in version 8.0 when the Nearest statement was added. Calculating the distance between 45 airport and the nearest coast line in Denmark tool close to 1 minute. Do remember that the distance is between the point and the closest part of the coast line. Calculating the distance between 21000 addresses and 45 airports took 30 seconds Calculating the distance between 45 airports and 21000 addresses took 30 seconds, too. Calculating the distance between 21000 addresses and 500 railroad stations took 2 minutes and 30 seconds. So it doesn't have to be that slow Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evan MacDougall Sent: Thursday, October 12, 2006 6: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
RE: [MI-L] SV: Distance calc mbx
or just use this statement: Set Table MYTABLE FastEdit On Undo Off Then MapInfo writes the changes directly to the files. Speeds things up dramatically, but you loose the Rollback posibility ;-) BTW, these suggestions require MapBasic and access to the source code behing DistanceCalcualtor Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Watertech - Jacob K. Jørgensen Sent: Thursday, October 12, 2006 8:34 AM 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
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
RE: [MI-L] SV: Distance calc mbx
We're using version 8.5. -Evan MacDougall GIS Supervisor Gentlemen, we may not make history tomorrow, but we shall certainly change the geography. -Original Message- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 12:11 PM To: Evan MacDougall; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SV: Distance calc mbx Which version of MapInfo are you using ? The Distance Calculator was improved in version 8.0 when the Nearest statement was added. Calculating the distance between 45 airport and the nearest coast line in Denmark tool close to 1 minute. Do remember that the distance is between the point and the closest part of the coast line. Calculating the distance between 21000 addresses and 45 airports took 30 seconds Calculating the distance between 45 airports and 21000 addresses took 30 seconds, too. Calculating the distance between 21000 addresses and 500 railroad stations took 2 minutes and 30 seconds. So it doesn't have to be that slow Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evan MacDougall Sent: Thursday, October 12, 2006 6: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
RE: [MI-L] SV: Distance calc mbx
I reduced the records first to 40K. Switched to a different machine. It ran overnight and was finished before morning. I don't know if: A. The machine made a difference or B. If the progress bar was really accurate since I stopped the mbx before it finished. I believe we are going to use MapExtreme to calculate the distances when we move to the actual application. I was just using the desktop to see if it would work. Also, we need a more specific distance than just every record in one table comparing to every record in another table. I believe Extreme will allow us to program more functionality. I am not a programmer, so I just happy to see it worked Mike Hankins -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evan MacDougall Sent: Thursday, October 12, 2006 2:26 PM To: Peter Horsbøll Møller; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SV: Distance calc mbx We're using version 8.5. -Evan MacDougall GIS Supervisor Gentlemen, we may not make history tomorrow, but we shall certainly change the geography. -Original Message- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 12:11 PM To: Evan MacDougall; mapinfo-l@lists.directionsmag.com Subject: RE: [MI-L] SV: Distance calc mbx Which version of MapInfo are you using ? The Distance Calculator was improved in version 8.0 when the Nearest statement was added. Calculating the distance between 45 airport and the nearest coast line in Denmark tool close to 1 minute. Do remember that the distance is between the point and the closest part of the coast line. Calculating the distance between 21000 addresses and 45 airports took 30 seconds Calculating the distance between 45 airports and 21000 addresses took 30 seconds, too. Calculating the distance between 21000 addresses and 500 railroad stations took 2 minutes and 30 seconds. So it doesn't have to be that slow Peter Horsbøll Møller GIS Developer, MTM Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evan MacDougall Sent: Thursday, October 12, 2006 6: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 winmail.dat___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
