Hi Simon If a locked entry is indicated by a boolean attribute in the index, then you shouldn't even need delta indexes. Thinking Sphinx now updates attributes on the fly, given the following: * The attribute is an integer, timestamp or boolean * The attribute is generated from a straight database column - not a manual SQL stirng
If your locking is a bit complex though, then Dan's suggestion about a custom delta indexer is probably the better solution. Cheers -- Pat On 14/05/2009, at 5:41 AM, Simon wrote: > > Hi, > > I have a situation where I have lots of users concurrently creating/ > updating entries that I have indexed. I think I can get away with > just running ts:index once an hour or so to get relatively up to date > results. My issue is that users also have the option to lock entries, > at which point they should not be returned by search results. If I > have delta indexing enabled, this works perfectly, however it also > really impacts the overall system performance, since the delta > indexing is also triggered for any other new/modify operation. > > What I would like to do is to be able to only trigger a delta index > when an entry is locked, and not when any other create/modify > operation is done. Is there a way to achieve this? The only other > option I can think of is to trigger a full index task when an entry is > locked, in addition to what I have scheduled in a cron job. > > I have also noticed that the UI hangs when an entry is created/ > modified, as the delta indexing is being done. Is there a way to push > this to a background or asynchronous process so that it doesn't > interfere with the UI rendering? > > Thanks, > > Simon > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to thinking-sphinx@googlegroups.com To unsubscribe from this group, send email to thinking-sphinx+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---