Home → Questions →

No subject

• Edit

Andrew

01 Jul, 2013 01:22 PM

My app has a very large database (100M+ records) on RDS and I would like to index only a portion of them in my local development environment. It simply takes too long, and too often times out, when I try to index the entire thing using rake ts:rebuild. How can I do this? Thanks.

1. Support Staff 1 Posted by Pat Allan on 01 Jul, 2013 01:42 PM

   

   Hi Andrew

   You can add a WHERE clause to your index definition:
   http://pat.github.io/thinking-sphinx/indexing.html#conditions

   This will allow you to limit your index data to just a small amount.

   Are you seeing issues when indexing via Flying Sphinx as well? Or just locally?

   Pat

   • Edit