Hello there! If I have a table with 100,000 records in and I have two columns in the table, one an ID field (int) numbered 1 to 100,000 that is indexed etc. The other field is a text field with say 100 words in each row.
What would produce the fastest search if I wanted to search for all entries that had a id>50,000 and contained the word 'CAT'. If this produced a result of 25,000 records, would it be quicker to do either: SELECT * FROM table WHERE idfield > 50000 AND MATCH textfield AGAINST('CAT' IN BOOLEAN MODE} or SELECT * FROM table WHERE MATCH textfield AGAINST('CAT' IN BOOLEAN MODE} AND idfield > 50000 The reason I ask this is because it would obviously be quicker to do a MATCH over 50,000 records rather than the complete 100,000 records. Thanks! Chris.. [query] ________________________________ http://www.exchangeandmart.co.uk IMPORTANT. Any views or opinions are solely those of the author and do not necessarily represent those of United Business Media. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message, please do not read, copy, use or disclose this communication and notify the sender immediately. It should be noted that any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. --------------------------------------------------------------------- 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