nzinfocoreseek-sphinx全文检索实践指南php.pptVIP

Searchd ..... 推荐的连接方式 Sphinx API PHP Python Ruby Perl SphinxQL MySQL 兼容客户端 Restful API By Coreseek，in developing Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Demo Code [PHP Client Side] Create a client object Set up the options Fire the query ?php include ( “sphinxapi.php” ); $cl = new SphinxClient (); $cl-SetMatchMode ( SPH_MATCH_PHRASE ); $cl-SetSortMode ( SPH_SORT_EXTENDED, “price desc” ); $res = $cl-Query ( “ipod nano”, “products” ); var_dump ( $res ); ? Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Demo Result [ PHP Client Side] Matches will always have document ID, weight Matches can also have numeric attributes * No string attributes yet (pull them from MySQL) print_r ( $result[“matches”][0] ): Array ( [id] = 123 [weight] = 101421 [attrs] = Array ( [group_id] = 12345678901 [added] = 1207261463 ) ) Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. DB Vs. Sphinx Who take the job? SQL query parts that can be moved to Sphinx Filtering – WHERE vs. SetFilter() or fake keyword Sorting – ORDER BY vs. SetSortMode() Grouping – GROUP BY vs. SetGroupBy() Up to 100x (!) improvement vs. “na?ve” approach Rule of thumb – move everything you can from MySQL to Sphinx Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Sphinx Searching pipeline Search, WHERE, rank, ORDER/GROUP “Cheap” boolean se