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.
Mysql Full Text Searc or Indexing
Moderator: General Moderators
Re: Mysql Full Text Searc or Indexing
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.
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.
Re: Mysql Full Text Searc or Indexing
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.
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
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.