I've a bunch of IDs fetched(around 60,000) from a DB.
I'm using these IDs to fetch data from another DB
having a related fields in its tables. I'm using IN
clause for it. i.e. for e.g. SELECT * FROM site_users
WHERE parentUserId IN (1,2,3,4....)
Again here parentUserId is Indexed.
The query is running fine for now. I wanted to know
how MySQL interprets and executes this query and can
it have problems in future if number exceeds 60,000??
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
