Limit on database size?

Is there a limit on the size of database that acts_as_ferret can handle?
I’m using mysql for my application, and substring search facility of
acts_as_Ferret appears to stop working when there is over 100,000 rows
in a table.