You will need to run an ec2 instance and put all the text to search in SimpleDB or S3, etc., then run Sphinx on EC2. The answer will be quick, since your heroku application is also on EC2. Thus, an EC2 instance could only handle text search, with a pretty Heroku website.
Tom andersen
source share