This is one of the solutions implemented to improve the functioning of a site following many SQL statements that greatly slowed the database. On average, the performance of each application took between 1 and 5 minutes to load the server, since they used those particular function MATCH ... AGAINST rather famous for his appetite.

The function is also like a little less greedy because the guidelines sought expressions can be a little more specific with sequences of OR Field1 Like '% ...%' OR field1 like '% ...%'.

The question was therefore to resolve this problem of slow SQL:

This application requires she be revived frequently as updates on the table or in relationship are many? this question, the answer was not necessarily.

The use of an intermediate table receiving query results is an excellent solution for dealing with the problems of slow queries with a definition of expiration for registrations. The first generation of the table will take some time but then it picks very quickly in the results thereof.

This time saving is significant since, instead of waiting 1 to 5 minutes the result of execution of requests, the waiting time is increased to 1 second or less. Mysql database is now well discharged, and that does more jammed. The bottleneck has finally disappeared.