Hi,
In this case, MI is not crashing. It is just that queries with a subquery based on objects are very time consuming. MI should be able to perform your query within a few hours. However, there is an alternative, which should be much faster:
Select tab1.id from tab1,tab2 where tab1.obj within tab2.obj into selection
Then revert the selection with:
Select * from tab1 where id not in (Select id from selection) into selection
-> this one can still takes minutes!!
id should be a integer or text column which uniquely identifies the records.
Hope this help
>>>>
Hi, I am running a simple select query for objects in two large datasets (few thousand records each). Unfortunately, MapInfo (v.5.0) crashes (not responding) after applying this query. I tested this for few records and the software is working fine. It seems that the problem concerns the size of the table?? I have lots of memory, fresh workspace and only these tables which are necessary. ( I have to run the query on objects not on records!) Any ideas what's wrong? Just in case, the query : select* from tab1 where not obj within any (select obj from tab2) into selection Thanks, Ewa
-----------------------------------------------------------------------
Richard Metzger, Swiss Federal Institute of Technology (EPFL)
Address : IATE-HYDRAM, DGR, EPFL, CH-1015 Lausanne, Switzerland
E-mail : [EMAIL PROTECTED]
Phone : +41 (21) 693 57 38
Fax : +41 (21) 693 37 39
----------------------------------------------------------------------- ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]