Make sure you have the right regular indexes and spatial index in your SQL Server database. Then the linked or cached MapInfo table will also hold these indexes speeding up your searches. So what you see happening is not creating a cursor in SQL, but MapInfo building it's own index because your spatial table doesn't have any.
Go into SQL Server enterprise manager and create the required indexes on your search columns. Kind regards, ------------------------------------ AVD-ICT Milo van der Linden GIS Consultant [EMAIL PROTECTED] Hoogbloklandseweg 24 4205 NE Gorinchem Netherlands tel: +31(0)183508150 fax: +31(0)183508160 mobile: +31(0)629540696 ------------------------------------ -----Original Message----- From: Cohen, Joel [mailto:[EMAIL PROTECTED] Sent: dinsdag 16 augustus 2005 9:23 To: [email protected] Subject: MI-L ODBC and mapinfo Has anyone experienced performance issues with a ODBC connection from Mapinfo to SQL server 2000. I have a table that has about 30K records, when I try and run a super simple query like id = "1" the search seems to create a cursor within SQL and subsequently search through all the items in the cursor. This is a very time consuming request, for a search that really should be very simple. Other Info: The table is alinked and cached. The data was loaded into SQL via the easy loader application from Mapinfo. Mapinfo Version 8 Regards Joel Cohen CAUTION: This message may contain privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message, you are hereby notified that any use, dissemination, distribution, or reproduction of this message is prohibited. If you have received this message in error, please notify the National Office of Neverfail Springwater Ltd immediately. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of Neverfail Springwater Ltd. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17502
