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 next 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
Re: Sphinx - only for string based search? [message #3045 is a reply to message #3024 ] Tue, 06 May 2008 00:46 Go to previous messageGo to next message
debug is currently offline debug
Messages: 128
Registered: March 2008
Senior Member
Sphinx is a full-text search engine, not SQL server Smile It can't speed up such queries.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Report message to a moderator
Re: Sphinx - only for string based search? [message #3047 is a reply to message #3024 ] Tue, 06 May 2008 03:35 Go to previous message
razdaman is currently offline razdaman
Messages: 26
Registered: May 2007
Junior Member
That was what I thought.

Thanks for the "confirmation"! Cool
Report message to a moderator
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 Jan 9 00:45:38 EST 2009

Total time taken to generate the page: 0.11910 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge