Re: full text search

Hi Amber

What storage engine were you using? Full text search is currently (MySQL 5.5) only available in myISAM, but the performance of InnoDB is much better in general.

One solution is to keep just the tables that require search in myISAM and move the rest.

J

On Jul 16, 2012 11:55 PM, "amber" <tekipconsulting@gmail.com> wrote:

Hi , 

I imported a DB (~100k rows) on which I am doing full text searches, 

In CloudSQL they are taking more than 30 seconds causing 

Apennine to exceed the request time limit. 

Any suggestions? Or are full text searches just too slow to be done in 

the GCS?