I am developing a search feature for a system that has around 200,000+ plus rows of data that needs to be searched. The data is sales and registrations data so the search will be over multiple fields and over multiple tables. Since the data between the tables is separate, the search needs to do something like this:
(`registrations`.`licensee` LIKE 'query%') OR (`registrations`.`organization` LIKE 'query%') OR (`registrations`.`address` LIKE 'query%') OR (`registrations`.`city` LIKE 'query%') etc... on the registrations table and sales table. My question is if Sphinx is right for this? I have read a lot about it but I can't find much information on if it relates to my problem. I know it's a full text search replacer, but will it be better than MySQL when it has to search over dozens of fields? -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
