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
