hello,

got a situation with my newly installed 5.0.3:

WinXP pro, P4 2.4G 256MB DDRAM

table1 35,000 rows, myisam, columnx auto_increment table2 40,000 rows, myisam, columny auto_increment

i executed the ff:

select * from table1 where columnz in (select columnz from table2 where columnz='this value doesnt exist')

and it takes my computer almost dead when it is only expected to yield no row.

i suspect on the structure of my tables. do i need to index columnz?

i really need the subquery feature for my application. any help is highly appreciated.

thanks

__________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: