difficult to
search the web on this topic, perhaps because I don't know the correct
terminology. I usually end up with results regarding the built-in fulltext
features of various databases. Any web links are appreciated. Surely there's
a way to do this efficiently using SQL queries.
h boolean value in its own
TINYINT?
Thanks for the advice!
Mike Boone
http://boonedocks.net/mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ults for "piano" would be cached.
So many variables to consider!
Thanks again for your input.
Mike.
-Original Message-----
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 9:25 PM
To: Mike Boone; [EMAIL PROTECTED]
Subject: Re: Optimizing Custom Full Text Index
: Wednesday, November 19, 2003 2:01 PM
To: Mike Boone; [EMAIL PROTECTED]
Subject: Re: Optimizing Custom Full Text Index
Have You tryed:
SELECT A.id, COUNT(A.id), A.category FROM A, C WHERE
C.content_id=A.id AND A.status='Active' AND (C.stem_word_id IN (10,20,30))
GROUP BY A.i
sidering compressing the text in that
field so save DB disk space. Is that worth the effort?
Any input is appreciated. Thanks for your help.
Mike Boone
(reply to the list or contact me directly at:
http://boonedocks.net/mailmike.php3)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
