… test I was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of…’ to clear the buffer. For the tests I used the table from the forum search engine, leaving just bunch of ids in it…
Page: Presentations
…Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx…search search engines such as lucene,sphinx,tbgsearch,sienna, mnogosearch and perform…
Post: FaceBook Search, Search for social networks
… of search engine externals. Simple filtering/sorting though is often supported by search engine …search only your friends. When I tested it search function was also a bit buggy. Doing search for the “test…sure Sphinx can be used efficiently to perform queries going beyond full text search. …
Comment: Full text search for all MySQL Storage Engines
…search in my tests. Speaking about Wildcards – as I know it is on the way. Wildcard search…mask and perform the search. I would suggest to write request on sphinx Forum. …engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full text search engines…
Comment: Full text search for all MySQL Storage Engines
…search is performed). By using vectors you can use simple bit arithmetics like if you want to perform AND search… until the engine can spit… during tests): Reversed …Sphinx: 16.31 seconds Vectorbased search: 0.06 seconds On xp3200+ windowsbox: Vectorbased search: 0.01 seconds I dont know how sphinx…
Post: Using Flexviews - part two, change data capture
…performance by identifying the data which has changed. Maintain materialized views with Flexviews (the primary purpose of FlexCDC). Feed search engines like Sphinx….test_demo. This because the source table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** …
Comment: Cache Performance Comparison
… Performance Comparison discussion but anyway, We’re now working on FullText Search Engine comparison for MySQL and test MySQL Build in Full Text Search, Siena, Sphinx, Lucene indexing Wikipedia database and performing appropriate queries…
Comment: Full text search for all MySQL Storage Engines
… the default mode in most fulltext engines and most likely because of this they will perform somewhat bad when you need a… heavy searches are common but they do exist). A sidenote was that the sphinx I tested was a beta version and that wildcard searches… the performance will increase aswell. In my case it would be much easier to use a ready solution such as sphinx instead…

