Hello everyone, I have a few questions that I hope some of you might be able to answer. Is there a MAX_SIZE on a select statements and when does MySQL lose performance when the statement becomes very large? When using the 'IN' clause, how does MySQL parse the data? Does it do an inline search or a binary tree? Thanks for your help... --Dave J. --------------- Dave W. Juntgen [EMAIL PROTECTED] Medical Informatics Engineering, Inc. http://www.mieweb.com/ 4101 W. Jefferson Blvd. Phone: 219-459-6270 Fort Wayne, IN 46804 Fax: 219-459-6271 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php