Full Text search

This topic is locked

Full Text search	4/16/2011 6:05:40 PM
PHPRunner General questions
L Lloyd author Hi, I have a very large mysql table with over 2 million records. one of the fields is a title which has been set to full text. Currently when I do a search on this field it takes a very long time to execute the search and display the results. Is there a way I can use a mysql select command with a where clause using match and against, instead of the mysql select command used by the search and advance search windows. I am also considering using Sphinx to increase the performance of current full text searches. Is there a way I can incorporate the Sphinx php script into phprunner. Regards, Lloyd


	Sergey Kornilov admin 4/17/2011
	This can be done. You'll need to implement BeforeSQLQuery event and build your own WHERE clause there. Here are a few links that can help: http://xlinesoft.com/phprunner/docs/modify_sql_query_on_the_fly.htm http://xlinesoft.com/phprunner/docs/print_search_parameters_on_list_page.htm