Hi Scott,
Here are a few of the steps that I have used to overcome MB performance.
These are fairly obvious tips really, but perhaps they'll help, or
prompt someone for better ideas.
1. Don't open any map windows if it can be helped. Open the tables as
"hide". A lot of time can be wasted
Scott,
I have found that you can speed up mapbasic/mapinfo by regularly closing and
opening the base tables that you use (don't ask me why) If you find that
the process is reasonably quick but then begins to slow down then the
following steps will dramatically help.
Keep a count of the number
I have received a number of useful responses, but most hinted that i need to provide a
little more info so here goes.
The piece of offending code contains 6 select queries (executed against 9000 objects)
of the form
SELECT x FROM table WHERE a = b INTO _temptable NOSELECT
NONE of the queries