RE: MI Speeding up mapbasic code

2000-04-26 Thread Van Uitregt, John
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

RE: MI Speeding up mapbasic code

2000-04-26 Thread Martin Roundill
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

Re: MI Speeding up mapbasic code

2000-04-26 Thread Scott Fagg
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