Received: by 10.114.109.1 with SMTP id h1mr792397wac.9.1200700241559;
        Fri, 18 Jan 2008 15:50:41 -0800 (PST)
Return-Path: <p...@freelancing-gods.com>
Received: from outbound.icp-qv1-irony-out2.iinet.net.au (outbound.icp-qv1-irony-out2.iinet.net.au [203.59.1.107])
        by mx.google.com with ESMTP id k36si7709295waf.0.2008.01.18.15.50.40;
        Fri, 18 Jan 2008 15:50:41 -0800 (PST)
Received-SPF: neutral (google.com: 203.59.1.107 is neither permitted nor denied by best guess record for domain of p...@freelancing-gods.com) client-ip=203.59.1.107;
Authentication-Results: mx.google.com; spf=neutral (google.com: 203.59.1.107 is neither permitted nor denied by best guess record for domain of p...@freelancing-gods.com) smtp.mail=...@freelancing-gods.com
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AgAAADPKkEfSVCuo/2dsb2JhbAAIrno
X-IronPort-AV: E=Sophos;i="4.25,218,1199631600"; 
   d="scan'208";a="268108181"
Received: from unknown (HELO [192.168.1.3]) ([210.84.43.168])
  by outbound.icp-qv1-irony-out2.iinet.net.au with ESMTP; 19 Jan 2008 08:50:41 +0900
Message-Id: <C24505DD-3CC8-4903-882A-EEC50A522AAD@freelancing-gods.com>
From: Pat Allan <p...@freelancing-gods.com>
To: rubyonrails-deployment@googlegroups.com
In-Reply-To: <93af4be9-c01d-4d5c-94e8-9baff9d1cdcf@i12g2000prf.googlegroups.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v915)
Subject: Re: [Rails-deploy] Re: sphinx vs ferret
Date: Sat, 19 Jan 2008 10:50:38 +1100
References: <a205f2880801040826g5722fd8dxcdf1d4a34227fa44@mail.gmail.com>  <F8BEF2C8-E39F-4E8D-BE16-70B290D4CC90@planetargon.com> <20080104113411.B92025@bravo.pjkh.com>  <7C5E8EAF-FC88-4564-AD45-0606D6DCD690@gmail.com> <3945c4270801041309i2bdc3cc2v21dfe4e31561f958@mail.gmail.com>  <863F72D2-A809-4367-8D3D-4B0D786BC24C@gmail.com> <2ef5f8330801050648x661bf0e1i4c5714ca54371c4f@mail.gmail.com>  <96811c60-6ef1-441c-ad7f-96c7b18eb61a@e6g2000prf.googlegroups.com>  <58537007-014e-4678-9069-c362996450bc@v67g2000hse.googlegroups.com>  <1a6cab0368310a96ab6729aafb261...@ruby-forum.com> <dc6a16a3-9f00-45aa-9b50-277f0e98e...@i72g2000hsd.googlegroups.com> <93af4be9-c01d-4d5c-94e8-9baff9d1c...@i12g2000prf.googlegroups.com>
X-Mailer: Apple Mail (2.915)

On 19/01/2008, at 10:17 AM, Jeff wrote:

> How difficult would it be to change over to Sphinx?


The overall process? Not hard, with the caveat Adrian mentioned (ie:  
advanced Ferret features).

But keep in mind Sphinx does not allow updating fields of index  
records (Ferret does) - you have to re-index to get the latest changes  
into Sphinx. There are ways around this, to some extent - delta  
indexes, containing just the recent changes - but it doesn't seem to  
be critical to everyone.

Essentially, though:
- Choose a sphinx plugin, and install it.
- Set up the configuration and indexes, either manually, or within  
your models (depending on the plugin)
- Install sphinx
- Index your data
- Switch your ferret-specific search calls to use the sphinx plugin's  
search calls.
- Start the sphinx daemon (searchd)
- Confirm everything works

Or something along those lines. I'm sure the EngineYard crew have a  
better idea though.

-- 
Pat
e: p...@freelancing-gods.com    || m: 0413 273 337
w: http://freelancing-gods.com || p: 03 9386 0928
discworld: http://ausdwcon.org || skype: patallan