in the city
Site wide search using mysql
I’m working on a site wide search using only mysql and not ferret or sphinx. I’m not ready to lift the veil but the big picture is:
- There is a search model and table where with a full text index
- Each model wishing to participate in searching responds to a callback function to create an index in the search table.
- Each model has a view that displays their results.
Anyone interested? So far the speed is very impressive and you don’t need to launch any additional daemons like sphinx and ferret require.
Back to work.