Dear all, I have an application that does an intersect between two tables containing region objects.
The SQL is along the lines of : Select SiteId, AvianId from tblLayer1, tblLayer2 where tblLayer1.obj intersects tblLayer2.obj into tblNewTable The problem that I have is that the new table contains a new region object representing the intersection (even if the obj column isn't listed) - which is perhaps what you would mostly want. I only need the non spatial columns. The big problem I have is that the intersection result is creating physical .map files in excess of 1.2 GBs, yes 1200MB (.map files any larger than about this seem crash MapInfo). The allied and larger problem is that the process is taking miles too long (and I need to do it several times for several different layers). Does anyone know how I can avoid the spatial region being created in the new table and thus reduce my run times? Thanks, Gregor Waddell The Royal Society for the Protection of Birds UK. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
