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 zooming, refreshing screens and
selections etc. by MapInfo. You can of course switch these off anyway.
2. Switch progressbars off, a lot of time can be wasted updating it, and
avoid window ownership conflicts etc.
3. Try using the same name for each query selection ie. "select some
columns into name_of_a_query". This might negate the need for dealing
with temp files, unless of course they are required for the select to
work.
4. Switch off screen savers, sleep modes etc. Sometimes they seem to
interfere with MapInfo operations ???
5. Move all data and software to local drive. Try not to have any
requirement for the network. I had a 55 hour operation stopped twice
because of maintenance on the network.
GOOD LUCK.
___________________________________
Regards ...
John van Uitregt, GIS Analyst
Logan City Council, Queensland, Australia
Tel. 61-7-38265697 Fax 61-7-38080014
Email: mailto:[EMAIL PROTECTED]
Web Site: http://www.logan.qld.gov.au
> -----Original Message-----
> From: Scott Fagg [SMTP:[EMAIL PROTECTED]]
> Sent: 27 April, 2000 9:42 AM
> To: [EMAIL PROTECTED]
> Subject: MI Speeding up mapbasic code
>
> I have a piece of mapbasic code that process a road network removing
> redundant nodes and links, leading to a substantially smaller map in
> terms of number of objects. This we then feed into a transport model
> (Emme/2)
>
> My problem is that the large size of the network (9000 nodes, 9000
> links) leads to very long run times for my process, ranging from 5 to
> 12 hours.
>
> The code is not especially complex but makes use of a lot of queries.
> Each iteration (one per node) involves probably at least 5 queries. I
> discovered the hardway that after mapinfo has processed 10000 queries,
> it hangs, having run out of available temp file names. I've resolved
> this by periodically closing all temp files from within my code.
>
> Are there any guidelines for optimising mapinfo code to extract more
> performance from it?
>
> Turning indexing on and off and had very little effect.
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and
> put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
> **********************************************************************
>
> If this Email contains Council related business then a copy MUST be
> forwarded to the Records Section for logging in the Records
> Management System.
>
> This email has been scanned and found to be free of all known viruses.
>
> **********************************************************************
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
