May 26, 2012

Post: Talking MySQL to Sphinx

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 Sphinxsearch 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 enginesearch 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…