Skip to main content

Full-text Search with Sphinx and PHP


Sphinx is an open source search server which combines very fast full-text search with a great scalability. It's growing up fast and we not only inventing new features for full text search itself, but also creating new ways to integrate Sphinx into PHP based applications.If you are not yet using Sphinx, we'll be highlighting some key steps on how to serve Full-Text queries to your PHP based applications from start to finish.

If you are an advanced Sphinx Search user, this talk will describe where one can offload MySQL or standard Database functions to Sphinx. From some specific queries one can run on the Sphinx to how to increase both performance and scalability of your applications (web-based or otherwise).

Besides tips and tricks centered around integration with PHP/MySQL based applications, you will learn about the recent 2.0.1 release straight from the proverbial 'horse's mouth.' This talk will utilize and focus on real-world examples from installation and integration to handling search results.

Sphinx is the acronym for SQL Phrase Index. Some key features of this search engine are (from official site):

1. high indexing speed (upto 10 MB/sec on modern CPUs)
2. high search speed (avg query is under 0.1 sec on 2-4 GB text collections)
3. high scalability (upto 100 GB of text, upto 100 M documents on a single CPU)
4. supports distributed searching (since v.0.9.6)
5. supports MySQL natively (MyISAM and InnoDB tables are both supported)
6. supports phrase searching
7. supports phrase proximity ranking, providing good relevance
8. supports English and Russian stemming
9. supports any number of document fields (weights can be changed on the fly)
10. supports document groups
11. supports stopwords
12. supports different search modes ("match all", "match phrase" and "match any" as of v.0.9.5)
13. generic XML interface which greatly simplifies custom integration
14. pure-PHP (ie. NO module compiling etc) search client API
Watch Online : 
http://www.ustream.tv/embed/recorded/14937201

Reference Links :

Comments

Popular posts from this blog

Overcoming Challenges in Adopting Generative AI in India

Adopting Generative AI in India presents several challenges, but it also offers significant opportunities for growth across various sectors. Here are some key obstacles and strategies to overcome them: 1. Infrastructure and Resource Limitations Challenge : India still faces issues with the availability of high-performance computing resources needed for generative AI models. This includes access to powerful GPUs and cloud services, which can be expensive. Solution : Partnerships with global tech firms can help bring advanced infrastructure to India. Government initiatives like the National AI Strategy and collaboration with research institutions can also boost local capabilities. 2. Data Privacy and Security Concerns Challenge : Data security is a significant concern, especially with the collection and usage of sensitive information. India's data protection laws, such as the Personal Data Protection Bill, are still evolving. Solution : Clear regulatory frameworks around data usage ...

Check and Use GZIP Compression through PHP

gzip compression is using for increase website speed and save server bandwidth. Read the below points to add gzip compression in your website: 1. Ask Hosting server provider to enable  gzip compresssion . 2. Compress all the css and js file using  7-zip  e.g. if your css file name is style.css it will save as style.css.gz. 3. Upload all the file on live server and set Content Encode GZIP to .gz files 4. Define  gzip global variable  in your common php file (remember the common file will include in all the php file into your website) $gzip_string=""; if (substr_count($_SERVER["HTTP_ACCEPT_ENCODING"], "gzip")) { $gzip_string=".gz"; }else{ $gzip_string=""; } 5. Put defined variable in all your script and style including in your php pages e.g. <link rel="stylesheet" type="text/css" href="css/my-style-file.css<?php echo $gzip_string;?>" /> <script type="text/javascript" ...

Why Indian PHP Development Companies Deliver Cost-Effective Solutions

In the world of web development, PHP remains one of the most popular programming languages, powering a vast majority of websites and applications. Businesses across the globe seek PHP Development Services to build scalable, secure, and high-performing web solutions. Indian PHP development companies have gained global recognition for delivering cost-effective solutions without compromising on quality. But what makes India a preferred destination for PHP development? Let’s explore the factors that contribute to the cost-effectiveness of Indian PHP development companies. 1. Competitive Labor Costs One of the primary reasons Indian PHP development companies can offer cost-effective solutions is the competitive labor cost. India has a vast talent pool of skilled PHP developers who are available at a fraction of the cost compared to developers in Western countries such as the United States, the United Kingdom, and Australia. This cost advantage allows businesses to allocate budgets more eff...