Page 1 of 1

Mysql Full Text Searc or Indexing

Posted: Wed Apr 09, 2008 12:40 am
by dharprog
Hi

Can anybody please tell me which is the best in real time Searching:

Either: 1) Mysql Full Text Search or 2) Index Searching.

Which is the better one to implement and what are the advantages and disadvantages?

Thanks and Regards,
DharProg.

Re: Mysql Full Text Searc or Indexing

Posted: Wed Apr 09, 2008 10:41 am
by pickle
The two aren't really separate as the FULL TEXT search uses a full text index. I've never heard of the term "Index searching" specifically, though adding indices to tables certainly does speed up SELECT queries.

FULL TEXT indices are built to help speed up searching for words - like a search engine. If that's your goal, use FULL TEXT indexes.

Re: Mysql Full Text Searc or Indexing

Posted: Wed Apr 09, 2008 11:47 pm
by dharprog
Hi

Thanks for the reply response.

Mysql full text is we can directly work on the table by specifying the columns for INDEX.

But where as in the INDEX search we create new tables in which we will split all the post content into words and store in the index tables. Here we take word count or percentage too.

For this we have to create a cron job operation to store the posts everyday.

Please go through the Drupals Indexing system there are different tables for Search module.

Thanks and Regards,
Dhar Prog.

Re: Mysql Full Text Searc or Indexing

Posted: Thu Apr 10, 2008 9:42 am
by pickle
I don't understand - what are you asking now?