Tag Archives: indexing

Powerful Full Text Search – Part 3 Solr

Introduction of Solr Solr is a standalone enterprise search server with a web-services like API. You put documents in it (called "indexing") via XML over HTTP (RESTful). You query it via HTTP GET and receive XML results. Advanced Full-Text Search Capabilities Optimized for High Volume Web Traffic Standards Based Open Interfaces – XML and HTTP [...]

Database – Tuning Tips

Understand Query Processing Basic Before tuning your slow query, you better understand how your database process your query first. Here are the steps: Each client connections gets its own thread within the server process (MySQL). The connetion’s queries execute within that single thread, which in turn resides on one core or CPU. The database server [...]

Art of using database indexes

Need of Indexes Image of you have a table of user info, if the table contains 50 million of rows. Without index, running a query like below will need a full table scan. Clearly it is not efficient as it is O(n) problem. SELECT * FROM user_info WHERE last_name = “Tom” But if we index [...]