Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Sphinx - only for string based search?
Sphinx - only for string based search? [message #3024] Tue, 29 April 2008 14:27 Go to previous message
razdaman is currently offline razdaman
Messages: 26
Registered: May 2007
Junior Member
"Generally, it's a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications."
(From sphinxsearch.com)

Does this mean that the sphinx engine only should be used when string based searches? Or would it also be able to boost performance of for example "SELECT user_id FROM users WHERE age BETWEEN 20 AND 26 ORDER BY last_login"?

Thanks in advance Smile
Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Previous Topic:Anyway to avoid temp table for this GROUP BY?
Next Topic:mysql process/thread id?
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 04:34:48 EDT 2009

Total time taken to generate the page: 0.02145 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.