I haven't quantified the "hit", as you have, but it's definitely there.
Speaking as a database geek, I don't think it's inherently necessary...
there's something about the way that MapInfo chooses to do the Access
connectivity that causes this. However, they may be stuck with it, given
that they want to stay cross-platform, and so the programmers probably can't
just manipulate ADO or RDO objects... which would make the indexing problem
go away, for example. (But MI would have to use the MDB indexes, not it's
own)
I'm happy just to be able to keep data in MDB format, but there could be a
LOT of improvement.
For major map crunching, I SaveAs back to native format, crunch away, then
SaveAs back to MDB format, and carry on with all the data intensive stuff I
have written in Access VBA code.
> -----Original Message-----
> From: Mitchell, Will [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 11, 1999 6:04 AM
> To: 'MapInfo-L'
> Subject: MI Performance using Access
>
> Hi all,
>
> We did a very simple test recently to quantify a perceived performance
> hit when using Access files with MapInfo. This is on a pentium 200,
> MapInfo 5, Windows NT - and is a simple workspace of US counties
> thematically shaded. Here's what we got;
>
> Data Source:total workspace loading(sec):indexing(sec):redraw time(sec)
> Native Mapinfo:10:0:5
> DBF:9:0:5
> Access:70:50:10
>
> Pretty dramatic slowdown. I understand that most of the time increase
> is the index rebuilding. The more important concern for us is the
> doubling of the redraw time (redraw in this case meaning the initial
> drawing of the map layers once all files and windows are open). We
> haven't done any further testing - but does anyone have any thoughts on
> the matter? It this a common experience?
>
> Thanks.
>
> Will Mitchell
> Geographic Services Coordinator
> The Environmental Company, Inc.
> Charlottesville, Virginia
> 804-295-4446
> [EMAIL PROTECTED]
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
