Bill Feel like I'd be trying to teach grandma to suck eggs but here goes:
How about establishing the state first, i.e. "Select streets.street_name from streets, states where states.name = "Colorado" and streets.obj within states.obj And is your states table indexed on name Just a WAG but it might help Terry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Thoen Sent: 14 June 2006 05:58 To: Terry McDonnell Subject: [MI-L] Performance of Large Tables and Spatial Selections I've got a large table of streets (the *.map file is a little over 1 GB) and when I display it over a table of state polygons and select all streets within a polygon by using a click with the Boundary Select tool, it does this in a few seconds. But when I try to do this with MapBasic via a selection like "Select streets.street_name from streets, states where streets.obj within states.obj and states.name = "Colorado" into MyStreets noselect" it's taking EONS to do this. Anyone know how I can get mapbasic to select streets within boundaries, and do it before I crumble into dust? _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
