I imported a DB (~100k rows) on which I am doing full text searches,
in a stand alone MySQL these searches take approximately 500ms under
load. In CloudSQL they are taking more than 30 seconds causing
Apennine to exceed the request time limit.
The table was originally MyISAM with fixed columns (char 255) to make
it faster. I tried converting it to InnoDB (as per GCS documentation)
but the performance in GAE remained the same.
Any suggestions? Or are full text searches just too slow to be done in
the GCS?
No comments:
Post a Comment