By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,313 Members | 1,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,313 IT Pros & Developers. It's quick & easy.

Key Word Searching

P: n/a
Hello

I am developing a web application that uses full text searching quite
extensively. This is ideal where I am searching a large number of
large varchar fields for a set of key words.

My problem is that each user on the site has a number of keywords in
the database (approx 200000 users) and when I add a new item with the
large varchar field I need to match all users who's keywords are found
within the varchar text.

I have not yet created the keyword section in the database so could
use either a keyword table with a record for each keyword such as

UserID INT
KeyWord VARCHAR(30)

or a single varchar field for each user that has a list of keywords.

I can think of some horrible solutions to this problem but figure
there must be something better.

Any ideas would be greatly appreciated.

Regards
Chris Chandler
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.