MySQL Forums
Forum List  »  MyISAM

Need Help with Fulltext Min_Word_Len AND resetting the Query Cache ???
Posted by: JDominguez
Date: February 12, 2006 03:17PM

I'm hoping that somebody out there can help me in beign able to do the following:

MySql version 4.1.xx (latest)

1. How do I set the ft.min.word.len from 4 to 3 ??

Some names like Ana or Joe would not appear!

I have tried but I cannot find a clear syntax or instructions to do this.

2. How do I reset the Query Cache, or stop it altogether ??

I have to reset the pc running the server every time I run a set of queries in order to compare the REAL time it would take to do the query! It is a pain!

I will be using a large database with several million rows that I wish to use FullText to better achieve query speed AND the QUERY values will be different about 99% of the time.

I have also read about compressed tables being faster and wonder how they would compare to regular tables with Fulltext OR if it will also work with Fulltext??

The data in this table will not change, at least not while active on the server.

Think of it as a telephone directory that holds a complete listing of telephone customers for a complete State.

Any help would really go a long way to saving my sanity :)

Thanks in advance to all

Julian Dominguez



Edited 1 time(s). Last edit at 02/12/2006 03:17PM by JDominguez.

Options: ReplyQuote


Subject
Views
Written By
Posted
Need Help with Fulltext Min_Word_Len AND resetting the Query Cache ???
4256
February 12, 2006 03:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.