Jesse Vincent wrote:
"Justin Hayes" <[email protected]> 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.
That is, IMHO, if you don't prefix queries for content with % which will
kill any and all indices on your table.
I have removed the pre/post pending of % from Searchbuilder because of
this. I rather have that people complain they can't find something then
that they kill the database. Now they know that if they want search for
content that they need to add a % at the end and if they really need it
at the front but they also know that they are gonna wait for it.
Regards,
Joop
