Mysql Full Text Searc or Indexing

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
dharprog
Forum Contributor
Posts: 126
Joined: Fri Oct 27, 2006 12:20 am

Mysql Full Text Searc or Indexing

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: Mysql Full Text Searc or Indexing

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
User avatar
dharprog
Forum Contributor
Posts: 126
Joined: Fri Oct 27, 2006 12:20 am

Re: Mysql Full Text Searc or Indexing

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: Mysql Full Text Searc or Indexing

Post by pickle »

I don't understand - what are you asking now?
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply