MapInfo v11 speed vs MapInfo v19
Louise Kavanagh
Dear All,
I have a series of MapBasic programs that were originally written to run in MapInfo v11. I have edited them to run from buttons on the ribbon in v19 but have noticed that they generally run approximately 50% slower in v19 then they do in v11. Has anyone else experienced this? If so is there a reason for the delay.
Thanks for your help.
Best wishes,
Louise
Louise Kavanagh
Managing Director
| louise....@apogeedata.co.uk | +44 (0)7736 438822
Peter Horsbøll Møller
Hi Louise
Yeah, you are not alone with this issue, Louise.
It seems the nice and shiny Explorer window is to blame, at least to a certain degree.
It has been discussed in this thread on the Knowledge Community.
Here are some things that can improve the performance:
- Close the Explorer window
- Use the NoSelect keyword when running Select statements that do not require a Selection to be highlighted
- Consider adding the Hide keyword to Select statements using NoSelect where the table doesn’t have to be visible to the end user
Here’s an example on how the NoSelect and Hide keyword can be used:
Select *
From ....
Into SomeQueryName NoSelect Hide
This article on the Community gives some general tips on improving performance in MapBasic applications.
But the three tips from above is what other users have found makes the difference when moving from 32-bit to 64-bit.
I hope this helps
From: mapi...@googlegroups.com <mapi...@googlegroups.com>
On Behalf Of Louise Kavanagh
Sent: 28. april 2021 11:49
To: mapi...@googlegroups.com
Subject: [MI-L] MapInfo v11 speed vs MapInfo v19
|
This message originated Externally. Use proper judgement and caution with attachments, links, or responses. |
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/mapinfo-l/007401d73c13%24ae3df460%240ab9dd20%24%40apogeedata.co.uk.
Louise Kavanagh
Closing the explorer window has made an improvement not only on speed but the amount of time a query takes to run is more consistent.
I am yet to try the NoSelect option but will see if it is applicable to the code.
Many thanks as always.
Best wishes,
Louise
From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Peter Horsbøll Møller
Sent: 29 April 2021 06:27
To: mapi...@googlegroups.com
Subject: RE: [MI-L] MapInfo v11 speed vs MapInfo v19
Hi Louise
Yeah, you are not alone with this issue, Louise.
It seems the nice and shiny Explorer window is to blame, at least to a certain degree.
It has been discussed in this thread on the Knowledge Community.
Here are some things that can improve the performance:
- Close the Explorer window
- Use the NoSelect keyword when running Select statements that do not require a Selection to be highlighted
- Consider adding the Hide keyword to Select statements using NoSelect where the table doesn’t have to be visible to the end user
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/MN2PR16MB31171294F034F6BF1ADF79D2965F9%40MN2PR16MB3117.namprd16.prod.outlook.com.
