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
