Maybe you can use Sphinx to search in Memcached

37 views
Skip to first unread message

Thorsten Kramm

unread,
Mar 1, 2010, 4:14:02 AM3/1/10
to MyHammer Open Source
If you want to search in memcached it should be possible to build a
sphinx index on top of your stored data in memcache.
Sphinx is designed to work on top of an SQL-database, but with the
universal xml input stream, it should be possible to dump the data
from memcache to sphinx.

Normally the data in memcache consists of serialized arrays. These
arrays can easily be converted in simple xml streams. These xml
streams are "piped" into the sphinx index. Sphinx uses your array keys
as attributes.

Now you can search in sphinx using your array keys as search criteria,
i.e. search for joe only in attribute name.
The sphinx php-api does not return any data. It only returns the exact
place where to look for the desired data.
This could be the identifier key from memcache.

The disadvantage of this idea is, that the sphinx index must be build
periodically.
But the advantage is that sphinx provides a powerful search mechanism
including full text search.

Kiessling, Manuel

unread,
Mar 1, 2010, 7:20:33 AM3/1/10
to Thorsten Kramm, myhammer-...@googlegroups.com
Hi Thorsten,

sehr cool, vielen Dank!

Steven, willst du dir das mal anschauen?

_________________________________________________

Manuel Kiessling
Director Product Development

Telefon: +49 30 23322-827
Telefax: +49 30 23322-899
Mobil:     +49 160 96990445
E-Mail:   
kies...@myhammer.de

MY-HAMMER Aktiengesellschaft
Mauerstr. 79
10117 Berlin
www.myhammer.de
_________________________________________________

Vorstand: Gerrit Müller (Vorsitz), Jan Seidler
Vorsitzender des Aufsichtsrates: Markus Berger-de León
Sitz der Gesellschaft: Berlin, Handelsregister Berlin,
 HRB 118291

 

Reply all
Reply to author
Forward
0 new messages