[rt-users] Content searching takes a long time and runs multiple queries

[Jesse Vincent]

"Justin Hayes" <justin.hayes at openbet.com> wrote:

>Any view on which is faster Jesse (postgres or mysql/sphinx)?
>

I haven't yet benchmarked em.

>Also how much faster than the old Content search are we talking? Orders
>of magnitude, or just 'faster'?

Having played with one of the implementations, it's night and day.

>
>Thanks again,
>
>Justin
>
>-------------------------------------------------
>Justin Hayes
>OpenBet Support Manager
>justin.hayes at openbet.com
>
>On 8 Dec 2010, at 16:48, Jesse Vincent wrote:
>
>> 
>> 
>> 
>> On Wed  8.Dec'10 at 16:44:57 +0000, Justin Hayes wrote:
>>> I was about to say that should have been 3.9 :)
>>> 
>>> Been a while since I checked out bestpractical.com. Just saw the
>post about the dev release, and looks like things are going well which
>is great news.
>>> 
>>> The only downside is the time needed to migrate to postgres, 
>> 
>> Or you could try the sphinx-based fts for mysql that's baked in
>> 
>>> and then the time it's going to take to port all my custom code into
>the new version.
>>> 
>>> But that's my problem, and one I have every time I upgrade, so can't
>complain!
>> 

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.