Sphinx

[dreamwest]

Has anyone got a live example of sphinx running?

 

I want to see how fast it is, and any opinions using it

[zq29]

I believe the search facility on these forums utilises Sphinx. I've used it on a couple of projects, depending on your data set and what you want to do with it, it can be extremely fast compared to something like MySQL. I had queries that took ~20 seconds on MySQL compared to less than a second on Sphinx.

[Daniel0]

I believe the search facility on these forums utilises Sphinx.

 

Indeed.

[Philip]

I had queries that took ~20 seconds on MySQL compared to less than a second on Sphinx.

 

I've had the same results many times too.

[dreamwest]

 

I believe the search facility on these forums utilises Sphinx.

 

 

Indeed.

 

 

Considering the speed you get from sphinx, do you think this query matches the performance:

 

 

$string = "foreach loops";foreach(str_word_count($string,1) as $word)$search_sql .= "+{$word} ";$res = mysql_query("SELECT * FROM `freaks` WHERE MATCH `topic` AGAINST('{$search_sql}' IN BOOLEAN MODE) ");

 

 

I have  40 Million + rows with 10 GB data and get queries < 0.5 secs

[zq29]

It's likely that Sphinx will be faster as it is designed to be a full-text search engine from the ground up, MySQL isn't.

[Philip]

Considering the speed you get from sphinx, do you think this query matches the performance:

 

$string = "foreach loops";
foreach(str_word_count($string,1) as $word)
$search_sql .= "+{$word} ";

$res = mysql_query("SELECT * FROM `freaks` WHERE MATCH `topic` AGAINST('{$search_sql}' IN BOOLEAN MODE) ");

 

I have  40 Million + rows with 10 GB data and get queries < 0.5 secs

 

Yeah, I'd imagine that'd be cut down to at least 0.2sec, if not less.

[ohdang888]

i finally got sphinx up and running on my site, but i'm using it for testing purposes right now, though.

[dreamwest]

i finally got sphinx up and running on my site, but i'm using it for testing purposes right now, though.

 

Well i managed to get my mysql queries down to < 0.3 secs (front end) by delaying key write, setting default order and using fulltext - let me know what you get.

 

Im working on a mod to get asynchronous results from mysql and instantly display them when a user clicks "submit", its more of a trick though