Home → Problems →

DJ delta indexing: Can I avoid delta indexing for non searchindex relevant model attribute changes?

• Edit

Nico

Aug 17, 2011 @ 02:58 PM

I have a user model that has a last_active attribute that is constantly updated when a user is logged in. Any such update causes sphinx to create delta indexing dj jobs, although no fields relevant for the serach are updated. How can I avoid this?

1. Support Staff 1 Posted by Pat Allan on Aug 18, 2011 @ 01:39 AM

   

   Hi Nico

   The following (or something similar) should do the trick:

   User.suspended_delta(false) { user.update_attributes(:last_active => Time.zone.now) }
   

   The false flag tells TS to not run a delta index request after the block is complete (it defaults to true).

   • Edit

2. 2 Posted by Nico on Aug 18, 2011 @ 06:10 AM

   

   Thanks, I give it a shot.

   • Edit

3. 3 Posted by Nico on Aug 18, 2011 @ 06:43 AM

   

   Just wondering if thinking sphinx could figure out automatically if relevant fields have changed on a save and then conditionally trigger the (delayed) delta indexing?

   • Edit

4. Support Staff 4 Posted by Pat Allan on Aug 18, 2011 @ 06:49 AM

   

   It does try to - but if you're using associations or SQL snippets in fields and attributes, it can't be sure, so it works with the assumption that it's better to fire a delta request.

   • Edit

5. 5 Posted by Nico Ritsche on Aug 18, 2011 @ 07:11 AM

   

   Ah, okay, sounds reasonable.

   Thanks for making sphinx available on Heroku by the way. Great job! ;-)

   • Edit

6. Support Staff 6 Posted by Pat Allan on Aug 18, 2011 @ 07:14 AM

   

   Thanks :)

   • Edit

7. Pat Allan closed this discussion on Aug 18, 2011 @ 07:14 AM.