June 19, 2013

Page: Presentations

… also give internal presentations for your company or group. Sphinx search engine for RDBMS Egypt, December 2007 Presentation about Sphinx, the tasks… text search functionality using real medium size text collection – Wikipedia Articles dump, when we compare it to other opensource full text search search engines

Comment: Cache Performance Comparison

The search engine uses chunked bitvectors where each chunk is 10kbit (1250 bytes … they dont have any chunk in common the search is halted and the engine reports “0 hits”. Currently it is only indexing…. The engine itself is currently available at http://www.tbg.nu/cgi-bin/news_search.cgi and works like google (AND search) with…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many customers… MySQL 5.6 is syntactically identical to MyISAM full-text search, in the sense that the SQL required to run a… same (modulo any new features introduced with InnoDB full-text search), that’s largely where the similarities end. NOTE 1: I…

Comment: Full text search for all MySQL Storage Engines

engines since the mysql fulltext has it limitations specially when used in boolean mode on large results (for example a boolean search… fulltext engine ?). However I found some issues with the standalone testversions which ended up with that I created my own fulltext search engine… I could do it any better for my case (fulltext search engine for a forum). What I have done is to mix…

Post: Talking MySQL to Sphinx

… Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries…. For the tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything else… results may be approximate – this is geared towards full text search applications when exact number is not important. Sphinx mysql> select…

Comment: Full text search for all MySQL Storage Engines

Apachez, I guess you’ve been experimenting with search engines in default settings which is quite frequently does not require … ranking and cutting of result set should be performed in search engine – you can’t do it in client well. Of course… relevance – there is an important difference between google and opensoure search engines. Google uses some very complex relevance ranking, which they would…

Comment: EuroOSCON 2006 - High Performance FullText Search

… I created TBGsearch was not to build a complete standalone search engine solution but to find a replacement of mysql fulltext for… case the problem with mysql fulltext were that my searches performed: * Using boolean search. * No stopword-list. * Sorting hits by date and… how large the difference would be if I created a search engine written only in perl with mysql as backend for the…

Comment: Full text search for all MySQL Storage Engines

… other full text search system with MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full text search engines behind it…

Post: Full Text Search Webinar Questions Followup

… key! Mario asked: Q: Did you compare relevancy of search results between each engine?  If yes, which one seems the best? No…, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries. Mike W. also asked: Q: What… only think of my company’s video library search).  Talking about the relevance of search results, sorry if it wasn’t clear…

Post: High-Performance Click Analysis with MySQL

… a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types… easy and familiar for me to use the example of search engine marketing. I’ll do that throughout this article. Requirements The… a solution that really needs to be solved with intelligent engineering, instead of massive resources. Conclusion This article has been an…