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

[Justin Hayes]

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

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

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!
>