Philip,
The interesting question is what actual is taking the time. Is it opening
the tables, showing these in a mapper or setting the layer settings for the
layers ?
I would recommend, that you add some MapBasic code to a copy of your
workspace to make some speed testing.
At the top of the workspace you write this (written in
bold):
******************************
!Workspace
!Version 400
!CharSet WindowsLatin1
Dim nTime As Integer
nTime = Timer()
******************************
Now whenever you
want to see how much tiime has been used, you can write some thing like
this:
******************************
...
Open Table
"C:\HereAreMyTable\MyTable.Tab" As MyTable
Print "Tables opened: " + (Timer() - nTime) + "
secs"
...
******************************
And at the bottom
of the workspace, you write:
******************************
...
Undim
nTime
******************************
I have used this
method to track down speed issues before. I mostly put the timing before the Map
>From and Set Map statements.
One thing that
might be time consuming is the default view of the tablee first put into the
map. This table will decide how thee map, should appear and how large a zoom
will be used. This has been a problem is previous versions of MapInfo, but it
should have been fixed with the latest patch for MapInfo 8.0
HTH,
Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
GIS Developer, MTM
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lesnik, Philip S.
Sent: Thursday, April 13, 2006 5:20 PM
To: MAPINFO Discusion Group
Subject: [MI-L] Speed up opening tables
Group.
I was wondering if
there is a way to speed up the process of opening up tables when starting a
workspace. Last year we bought Terrain Data for the whole US which is over
900 tables. We have all 900 tables set up in our main .WOR templates that
we use. It takes about 45 seconds to open the workspace because of the 900
additional tab files. Is there a way to speed up the process? I
messed around with merging some tables but it didn't work, so I gave up.
Any ideas?
Thanks
Philip Lesnik
Research Systems
Analyst
Market Research Dept.
General Growth Properties
NYSE: GGP
Phone: 312-960-2998
BSC - 3N13G
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
Notice:
This e-mail including attachments) is covered by the
Electronic
Communications Privacy Act, 18 U.S.C. §§ 2510-2521, is
confidential and may
be legally privileged. If you are not the
intended recipient, you are hereby
notified that any retention,
dissemination, distribution, or copying of this
communication is
strictly prohibited. Please reply to the sender that you
have
received the message in error, then delete it. Thank
you.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
