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 ...

Android Application Development In Mumbai

Android is quite busy in conquering the mobile application development market and there are plenty of companies which have headed towards android app development projects. It is an open source platform. The popularity of the Android is increasing rapidly and plenty of web developers are trying to make best use of the mobile platform. Android app developer Mumbai has amazed the entire world with their marvelous success in the mobile application industry. The android apps created are highly reliable and robust in nature when compared to other platforms. Tools and technologies used in android app development Most of the mobile app developers rely on Java language. With the recent developments on the Android platform, the developers have started developing the application with the support of the latest version of Adobe Air technologies and Adobe flash. Android SDK is used by the developers in mobileapp development in mumbai for writing code, testing and debugging the apps. ...

Startup AI Innovation in India

India's startup ecosystem has been booming with AI-driven innovation across various industries, including healthcare, finance, retail, agriculture, and education. Here’s an overview of the AI innovation landscape among Indian startups : Top AI-Focused Startups in India Uniphore Focus: Conversational AI and automation for customer service. Highlights: Specializes in speech recognition, natural language processing, and emotion analysis. Arya.ai Focus: AI for financial services, including risk assessment and fraud detection. Highlights: Known for modular AI solutions that are scalable and customizable. Niramai Focus: AI-powered early breast cancer detection. Highlights: Uses thermal imaging and machine learning for non-invasive, affordable diagnosis. SigTuple Focus: Healthcare diagnostics automation. Highlights: AI tools for medical imaging analysis, pathology, and ophthalmology. CropIn Focus: Agri-tech solutions. Highlights: Uses AI for crop health monitoring, farm management, and yi...