Jobs site search engine doubt - Sphinx is the solution??

Question

Hi... im developing a web app to manager jobs, curriculum and etc...

For example in my case: I have a CV table which contain some information about... and same fields in my table, is a reference to others tables like (Kind of company, kind of job looking for, education, languages the guy knows... a ordinary cv model)

My doubt is ... the sphinx is a good search engine? i need to search like: A person, who have X years of experience in YYY area with XXX grade complete ...

I dont know other websites out of Brazil... but i guess its a "ordinary job/cv search"...

Sphinx can be applied for this purpose? Or build each querys is the best cause i have one or more "select box filters"??

Real tkz to all! Roberto

Answer 1

Hi Roberto,

I'd say that yes, you could use Sphinx for this kind of search (and it would surely be very fast), but the kind of fields you want to search on are really better served directly within the database - making some assumptions that you're providing good indexes on the tables.

The real strength of Sphinx lies in full-text search, which you don't indicate you'll need. If you do find you need to index the full content of the CVs provided, then Sphinx starts to look more appropriate.