dreamwest Posted September 18, 2010 Share Posted September 18, 2010 Has anyone got a live example of sphinx running? I want to see how fast it is, and any opinions using it Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/ Share on other sites More sharing options...
zq29 Posted September 18, 2010 Share Posted September 18, 2010 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. Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1112409 Share on other sites More sharing options...
Daniel0 Posted September 18, 2010 Share Posted September 18, 2010 Quote I believe the search facility on these forums utilises Sphinx. Indeed. Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1112461 Share on other sites More sharing options...
Philip Posted September 18, 2010 Share Posted September 18, 2010 Quote 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. Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1112490 Share on other sites More sharing options...
dreamwest Posted October 7, 2010 Author Share Posted October 7, 2010 Quote Quote 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 Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1119704 Share on other sites More sharing options...
zq29 Posted October 7, 2010 Share Posted October 7, 2010 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. Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1119710 Share on other sites More sharing options...
Philip Posted October 7, 2010 Share Posted October 7, 2010 Quote 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. Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1119791 Share on other sites More sharing options...
ohdang888 Posted October 10, 2010 Share Posted October 10, 2010 i finally got sphinx up and running on my site, but i'm using it for testing purposes right now, though. Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1120719 Share on other sites More sharing options...
dreamwest Posted October 10, 2010 Author Share Posted October 10, 2010 Quote 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 Link to comment https://forums.phpfreaks.com/topic/213716-sphinx/#findComment-1120728 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.