[Brug-talk] Ferret - sphinx - Solr

[Peter Vandenabeele]

On Jan 24, 2008 1:28 AM, Peter Vandenabeele <peter at vandenabeele.com> wrote:
> On Jan 23, 2008 11:19 PM, Peter Vandenabeele <peter at vandenabeele.com> wrote:
> > 2008/1/21 Peter De Berdt (10-forward) <peter at 10-forward.be>:
> > >  Sadly, sphinx is out of the question, it doesn't support wildcard searches
> > > as our customers are used to apparently, searches for "pet*" don't return
> > > "Peter" records for example. I may have missed something, but this is a
> > > feature we can't live without.
>
> Test set of 6500 records with 3 fields of approx. 800 bytes/records (4.8 MBytes)
> (using a few bash and linux manuals as source text).

I have some more test data on multi-table  indexing and searching in a somewhat
larger set (34,000) with a belongs_to relationship to the first
(6,000) records set.
Might be useful even if the data is not very "scientific" and my
machine was also
swapping to disk during the first half of the testsm which may explain
some of the
20 - 30 ms search time that i sometimes saw.

  http://www.vandenabeele.com/Ultrasphinx-performance

HTH,

Peter