Best Approach For Speed

Hey guys,

I need some help on this problem.

I have a paragraph of about 2000 characters some hundred words. I have a database of 30,000 Full Names names.

I need to search through this text and find ALL occurrences of full names that I have a database entry on, and replace them with the string *Full Name*

I am building this into an api, so if I send a blob of text over, it will auto search and replace.

Can this be done rapidly, how could I go about doing this? Would I need to seach my blob of text 30,000+ times to see if a name is in there?

I appreciate you help, hope I made sense.

adbox

 

You could look at using myisamfulltext as an index on the column so you can query it with your searches. Should be pretty quick with a database that small.

 

Does a fulltextindex only apply to one field?

 

Ok, so I have one field now for 20,000 rows. I understand when I have a keyword and need to search large text stored in the database, but in this case I have a database of keywords and need to search my out of database text. (I'm still reading documentation on Matching at the moment), but maybe you could better bring this to light?

 

Final documentation: A fulltext can be applied to up to 16 fields, but no more. A good way around this is to build a new field and combine the text into that field as a fulltext reference field.