English 中文(简体)
何时使用间谍搜查?
原标题:When to use sphinx search, when to use normal query?

我正在使用“铁路中的sp”。 我知道,Sphinx用于全文检索。 我要说的是:

keyword
country
sort order

I use Sphinx for all the search above. However, when I am querying without keyword, but just country and sort order only, is it a better to use just normal query in MySQL instead of using Sphinx?

换言之,只有在查询<条码>关键词/代码>时才使用Sphinx?

审视总体业绩和速度。

最佳回答

基准! 基准! 基准!

Ie test it yourself。 具体业绩将视准确数据而有所不同,甚至可能甚至取决于你间谍和我的服务器的相对偏差。

问题回答

不是健全的词汇,而是业绩的真正问题?

If you re building an application which will only be used by a handful of users within an organization, then you can probably dismiss the performance benefits of using one method over the other and focus instead on simplicity in your code.

另一方面,如果许多用户在网站和网站上查阅你的申请,那么,如果需要把注意力集中在做事上,那么你就应当遵循“@barryhunter”的建议,在某种情况下确定最佳办法。

P.S. Dont在你需要之前取得最佳效果。 与你们的心灵作斗争,使你们的法典脱离。

Sphinx在用一个数字钥匙搜索时,会向MySQL提供杀手,而MySQL可能更快。

因此,假定“国家”和“短期命令”都可以采用MySQL的数字指数进行指数化,最好只用“关键词”来计算Sphinx,而其他两个——MySQL正常查询。

然而,正如大炮所建议的那样,基准却遭到伤害;





相关问题
rails collection_select vs. select

collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...

SSL slowness in EC2

We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...

Auth-code with A-Za-z0-9 to use in an URL parameter

As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...

RubyCAS-Client question: Rails

I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?

activerecord has_many :through find with one sql call

I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

Text Editor for Ruby-on-Rails

guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...