wiseleyb wrote: > I'm implementing delta indexing on our app using delayed job (which is > awesome - thanks!). > > Indexing our DB from scratch currently takes about 30 minutes. > > Given that: > > 1) I'm assuming I still need to rake ts:index once in a while (wasn't > sure if that was for all delta indexing or just the "real time" first > option on http://freelancing-god.github.com/ts/en/deltas.html )?
Yes, you will want to do a full re-index periodically. > 2) If I need to reindex do I do a ts:index or ts:rebuild? Anything > else - or just that? Any need to ts:stop ts:start? Just a ts:index. You only need to do a rebuild if your index definitions ahve changed. No need to stop and start. > 3) How often should I do a complete reindex? It depends on the rate of change in your data. Basically you'll need to do it once each delta index delayed job starts taking "too long". In my case I considered "too long" to be more than 3-4 seconds - above that my queue started to back up. I seem to hit that after about 24 hours, so I have a nightly rake task that doesa full reindex. -- James Healy <[email protected]> Wed, 26 May 2010 12:16:06 +1000 -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
