Hi Erik Ideally, the if you're using the old value in a search, it shouldn't return the record. While both records remain in the core and delta indexes, Thinking Sphinx flags it as deleted (from a TS perspective, not a Sphinx perspective) in the core index.
That said, it does take a second or two for Sphinx to catch up on index changes - are you allowing for this in your tests? And I realise delayed deltas are more work, but normal deltas is not going to work if you have more than one web server, and/or if you don't have that secure tunnel to the other server. Delayed deltas should also work neatly without that tunnel, too. Something to keep in mind if your site expands. Cheers -- Pat On 15/02/2010, at 12:53 PM, Erik Landerholm wrote: > Hi Pat- > I do have sphinx only running on one server, my database server. > > I don't want to use delayed deltas because i need to have the search > available right away for a couple of things. > > What I have is an index that isnt' updated all that often, but when it is > it needs to be available right away. What I have now is working well, but > the issue was with the rotate...or my lack of understanding anyway. > > When I do the rotate it seems like the old index is still available. If i > change the name for example on my Buyer model i can search by the old name or > the new name until the full index is done...this is done every hour. > > Is rotate supposed to clear out the old index or will they both be > available until a full index occurs? I figured the rotate would add the new > index and the old one would be gone, but that may not be true. > > Thanks. > Erik > > On Sun, Feb 14, 2010 at 5:28 PM, Pat Allan <[email protected]> wrote: > Hi Erik > > If you're using multiple servers, then I really recommend you use delayed job > deltas, and keep your Sphinx setup on your database server. > > Also, to deal with ThinkingSphinx.sphinx_running? never being true, you can > tell your site to presume that Sphinx is *always* running. Add something like > the following to the end of your environment.rb file: > > ThinkingSphinx.remote_sphinx = true if Rails.env == 'production' > > You can't put this in production.rb, as TS isn't loaded yet (and while it > won't raise errors, TS will get reloaded, and the setting reset). > > Hope this is helpful. > > -- > Pat > > On 15/02/2010, at 7:36 AM, erik wrote: > > > So I added my own custom code for production > > i do an ssh db_server " index command" and that works. i only use > > this on my low volume indexes. > > > > the other question is : > > after doing a rotate i notice that my old index still exists. > > > > if i change someone's name from 'bob miller' to 'steve miller' i > > notice that the 'bob' index is still active, but now points to a > > record with the name 'steve miller'. Only after i do a complete index > > is this cleared up. > > > > is that normal? > > > > thanks. > > erik > > > > On Feb 14, 12:02 pm, erik <[email protected]> wrote: > >> I have an issue with delta indexing. > >> > >> My setup is two web servers connect to a db server where sphinx is > >> running. Searching works fine. > >> > >> The issue is with deltas. > >> > >> This line: > >> ThinkingSphinx.sphinx_running? will never be true > >> > >> But, even if I could ignore that line how do i send a rotate command > >> to a sphinx instance running on a different server? > >> > >> should i just set up a cron job to rotate all indexes every minute or > >> use delayed indexes only? > >> > >> thanks. > >> Erik > > > > -- > > 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. > > > > -- > 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. > > > > > -- > Erik Landerholm > CTO, CarWoo Inc. > [email protected] > 503 317 2169 > > http://www.carwoo.com > > Follow us on Twitter > http://www.twitter.com/carwoo > > -- > 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. -- 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.
