Sphinx介绍.pptVIP

Sphinx介绍 相对于Lucence的优势 实时索引 索引建立速度快（可达10MB/秒，而Lucene建立索引的速度是1.8MB/秒） 支持分布式 对比图表 增删数据 Replace into fullTextSearch values (#Id#,#Title#,#Tag#,#Content#) Delete from fullTextSearch where id=#value# 搜索查询 select *,@weight+extweight*400+date_added/2000000000000 as totalweight from fullTextSearch where match(#KeyWord#) AND bigtypeid=#BigTypeId# order by totalweight desc limit #SkipResults#,#MaxResults# Option ranker=proximity_bm25,field_weights=(title=10,tag=8,body=4) SHOW META; 字段配置 rt_field = title rt_field = tag rt_field = content rt_attr_bigint = guid rt_attr_float = gpa rt_attr_times