Indexing is good, when you are selecting data. But it slows down many
other functions in MapInfo. Create it, use it, drop it.
____________
Kent Treichel
Analyst-GIS
Tax Research
Minnesota Department of Revenue
MS 2230
600 North Robert St
St. Paul, MN 55146-2230
651-556-6150
|---------+--------------------------->
| | "Marty Sprenz" |
| | <[EMAIL PROTECTED]|
| | lting.com> |
| | |
| | 01/22/2004 01:23|
| | PM |
| | |
|---------+--------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: "'Melissa Blackwell'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: MI-L slow query
|
|
|
>------------------------------------------------------------------------------------------------------------------------------|
WOW! Indexing took the select query process from > 30m to < 1m. Thank
you for the suggestion.
Marty
-----Original Message-----
From: Melissa Blackwell [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 1:10 PM
To: Marty Sprenz; [EMAIL PROTECTED]
Subject: RE: MI-L slow query
Yes Marty, Indexing is pretty much a "must" when working with large
amounts of data.
Go into the Table>Maintenance>Table Structure & Index the ID field and
any other field which you might need to search. (Indexing does increase
the file size so you don't want to index every field - just the ones you
need like ID.)
MI will close the Map & Browser Windows when you Index the table, but
after that you should see a dramatic improvement in your query times.
Melissa Blackwell
Training & CRM Administrator
Empower Geographics
Work: (847) 299-6952 x416
Cell Phone: (847) 910-2404
www.empower.com
Stay informed on important news!
Subscribe to our eLetter here:
<<http://www.empower.com/eLetter>>
How will moving to a new business location impact the people you serve?
Find out with Empower Relocator!
<http://www.empower.com/MapPoint/relocator.htm>>
Check out our new Demographic solutions area:
<http://www.empower.com/Demographics/index.htm>>
Need a refresher course on MapInfo? Come to a training class and use our
powerful new computers!
<http://www.empower.com/pages/training.htm>>
-----Original Message-----
From: Marty Sprenz [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 11:57 AM
To: [EMAIL PROTECTED]
Subject: MI-L slow query
I have a table with around 2.5 Mil records. It takes 30 minutes to do a
simple select query. Is there a way, such as indexing, that I could
speed up the query process?
Currently I'm selecting records based on the value in an ID field in
MapInfo 7.0.
Marty
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10068
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 10069
