|
FWIW,
I just
tested some variations with Set Map Redraw and Set Event Processing (Set
Progress Bars didn't have any bearing on these speed tests, only with window
focus).
I have
a database update today with 2100+ records. I have an mbx I use on such a daily
table that deletes all the graphic objects from the table, packs then
re-geocodes the table.
With
"Event Proccessing Off"
Took 6
seconds to refresh the table (delete graphic objects, pack the table then
re-open the layer)
13
seconds to geocode
With
"Set Map Redraw Off"
8
Seconds to refresh the table as above
27
Seconds to Geocode
Needless to say, I'm changing "Set Map Redraw" to "Set Event Processing"
in my MBX that handles the 40k records database.
Thanks
for the tips and suggestions everyone.
Dave -----Original Message-----
From: Simon Allen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 11:42 AM To: David Reid; [email protected] Subject: RE: [MI-L] Mapbasic stops when window is no longer active David
Not sure about this.
However, some observations:
Ta
From: David Reid
[mailto:[EMAIL PROTECTED]
Sent: 30 March 2006 18:33 To: Simon Allen; [email protected] Subject: RE: [MI-L] Mapbasic stops when window is no longer active No! sorry not to be clear on this. The progress bars aren't
displaying, however, this process (as shown in my code) takes longer than if I
did the same tasks manually.
Furthermore, if I bring another program window into focus over MI, the
process in my example either stops (as indicated in the first part of this
thread) or slows down even more.
Dave
-----Original Message-----
From: Simon Allen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 11:26 AM To: David Reid; [email protected] Subject: RE: [MI-L] Mapbasic stops when window is no longer active David
You imply that at some point during the execution Progress
Bars are displaying?
At which point?
ta From: David Reid [mailto:[EMAIL PROTECTED] Sent: 30 March 2006 18:19 To: Simon Allen; [email protected] Subject: RE: [MI-L] Mapbasic stops when window is no longer active I'm
glad this came back up. I was unclear about something in th Mapbasic UG
and Ref guide.
Are
there certain commands that will cause ProgressBars to automatically be
re-enstated without issueing "Set ProgressBars On"?
For
instance, if I "Set Progressbars Off", can a "Commit Table" command reset or
turn "Set ProgressBars Off" back to "On"?
For
example, here's a snippet of an MB I use to refresh a table I regularly
"re"geocode, of about 40k records.
In
order to try and speed up the process, I've set progressbars off, redraw off and
drop the index on any indexed fields:
Set Progressbars Off
Set map redraw off drop index MYTABLE (FIELD1) drop index MYTABLE (FIELD2) drop index MYTABLE (FIELD3) ' The following line deletes the graphic objects in the selection Delete Object From MYTABLE ' The following line Saves the table Commit Table MYTABLE ' The following line packs both graphics and data of the table Pack Table MYTABLE Graphic Data 'The following lines rebuilds the index of the specified columns Create Index On MYTABLE (FIELD1) Create Index On MYTABLE (FIELD2) Create Index On MYTABLE (FIELD3) Set map redraw On Set Progressbars On So, is the "Commit" or "Pack table" statements turning progress
bars back on?
The above takes far more time programattically
than manually and requires me to nurse Mapinfo the whole time by
keeping it in front.
Thanks,
David
Reid
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Allen Sent: Thursday, March 30, 2006 10:17 AM To: [email protected] Subject: RE: [MI-L] Mapbasic stops when window is no longer active Hi Joe
Submitted a similar request myself recently . You need to
disable Progress Bars: with "Set ProgressBars Off".
Ta From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Nunn Sent: 30 March 2006 16:30 To: [email protected] Subject: [MI-L] Mapbasic stops when window is no longer active Dear
All, I am sure this has been asked before
but here goes… I have program that runs fine, but when I start using another
program (ie move the active window) mapinfo appears to halt. When I make the
mapinfo window active again it continues to process files. Any ideas how
to make it run while using another application? Joe
Nunn The XYZ
Digital Map Company Unit 9 Phase
2 Hardengreen Business Park Tel: +44 131
454 0426 Fax: +44 131
454 0443 E-mail:
[EMAIL PROTECTED] Web:
www.xyzmaps.com -- -- -- -- -- -- |
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
