blocks|key|4450302|text|根据手册：SphinxClient::setLimits，|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4450303|这应该能起到作用|4450304|++$cl->SetLimits(0,0);|code-block|syntax|javascript|4450305|我不是Sphinx开发人员，所以这只是一个盲目的猜测...它应该避免出现大量结果的内存溢出。|4450306|让我知道它是否工作，以便我可以删除答案，如果这是不正确的。|4450307|我还发现SELECT..COUNT()在Sphinx+query中不能工作，所以这一点你是对的。|style|CODE|4450308|此外，根据Sphinx文档，您可以使用SHOW+META+query检索大量结果。|4450309|显示元数据|4450310|SHOW+META显示有关最新查询的其他元信息，如查询时间和关键字统计信息：|BOLD|4450311|mysql>+SELECT+*+FROM+test1+WHERE+MATCH('test%7Cone%7Ctwo');
%2B------%2B--------%2B----------%2B------------%2B
%7C+id+++%7C+weight+%7C+group_id+%7C+date_added+%7C
%2B------%2B--------%2B----------%2B------------%2B
%7C++++1+%7C+++3563+%7C++++++456+%7C+1231721236+%7C
%7C++++2+%7C+++2563+%7C++++++123+%7C+1231721236+%7C
%7C++++4+%7C+++1480+%7C++++++++2+%7C+1231721236+%7C
%2B------%2B--------%2B----------%2B------------%2B
3+rows+in+set+(0.01+sec)

mysql>+SHOW+META;
%2B---------------%2B-------%2B
%7C+Variable_name+%7C+Value+%7C
%2B---------------%2B-------%2B
%7C+total+++++++++%7C+3+++++%7C
%7C+total_found+++%7C+3+++++%7C
%7C+time++++++++++%7C+0.005+%7C
%7C+keyword[0]++++%7C+test++%7C
%7C+docs[0]+++++++%7C+3+++++%7C
%7C+hits[0]+++++++%7C+5+++++%7C
%7C+keyword[1]++++%7C+one+++%7C
%7C+docs[1]+++++++%7C+1+++++%7C
%7C+hits[1]+++++++%7C+2+++++%7C
%7C+keyword[2]++++%7C+two+++%7C
%7C+docs[2]+++++++%7C+1+++++%7C
%7C+hits[2]+++++++%7C+2+++++%7C
%2B---------------%2B-------%2B
12+rows+in+set+(0.00+sec)|4450312|参考：|4450313|4450314|Sphinx:+SHOW+META+syntax|unordered-list-item|4450315|SphinxClient::setLimits|4450316|4450317|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/sphinxclient.setlimits.php|1|http://sphinxsearch.com/docs/1.10/sphinxql-show-meta.html|2^0|5|N|0|0|0|0|0|0|4|F|0|0|0|0|9|0|0|0|3|0|0|0|O|1|0|0|N|2|0|0^^$0|@$1|2|3|4|5|6|7|1L|8|@]|9|@$A|1M|B|1N|1|1O]]|C|$]]|$1|D|3|E|5|6|7|1P|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1Q|8|@]|9|@]|C|$I|J]]|$1|K|3|L|5|6|7|1R|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|1S|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|1T|8|@$A|1U|B|1V|Q|R]]|9|@]|C|$]]|$1|S|3|T|5|6|7|1W|8|@]|9|@]|C|$]]|$1|U|3|V|5|6|7|1X|8|@]|9|@]|C|$]]|$1|W|3|X|5|6|7|1Y|8|@$A|1Z|B|20|Q|Y]]|9|@]|C|$]]|$1|Z|3|10|5|H|7|21|8|@]|9|@]|C|$I|J]]|$1|11|3|12|5|6|7|22|8|@$A|23|B|24|Q|Y]]|9|@]|C|$]]|$1|13|3|-4|5|6|7|25|8|@]|9|@]|C|$]]|$1|14|3|15|5|16|7|26|8|@]|9|@$A|27|B|28|1|29]]|C|$]]|$1|17|3|18|5|16|7|2A|8|@]|9|@$A|2B|B|2C|1|2D]]|C|$]]|$1|19|3|-4|5|6|7|2E|8|@]|9|@]|C|$]]|$1|1A|3|-4|5|6|7|2F|8|@]|9|@]|C|$]]]|1B|$1C|$5|1D|1E|1F|C|$1G|1H]]|1I|$5|1D|1E|1F|C|$1G|1J]]|1K|$5|1D|1E|1F|C|$1G|1H]]]]

According to manual: <a href="http://www.php.net/manual/en/sphinxclient.setlimits.php" rel="nofollow">SphinxClient::setLimits</a>,

This should do the trick

<pre><code> $cl-&gt;SetLimits(0,0);
</code></pre>

I'm not Sphinx developer, so this is just a blind guess... It should avoid memory
overflow with large number of results.

Let me know does it work so I can remove answer if this is not correct.

I've also found that <code>SELECT..COUNT()</code> doesn't work in Sphinx query, so you're right about that.

Also, according to Sphinx documentation, you can retrive number of results using SHOW META query.

<h2>SHOW META</h2>

SHOW META shows additional meta-information about the latest query such as query time and keyword statistics:

<pre><code>mysql&gt; SELECT * FROM test1 WHERE MATCH('test|one|two');
+------+--------+----------+------------+
| id | weight | group_id | date_added |
+------+--------+----------+------------+
| 1 | 3563 | 456 | 1231721236 |
| 2 | 2563 | 123 | 1231721236 |
| 4 | 1480 | 2 | 1231721236 |
+------+--------+----------+------------+
3 rows in set (0.01 sec)

mysql&gt; SHOW META;
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| total | 3 |
| total_found | 3 |
| time | 0.005 |
| keyword[0] | test |
| docs[0] | 3 |
| hits[0] | 5 |
| keyword[1] | one |
| docs[1] | 1 |
| hits[1] | 2 |
| keyword[2] | two |
| docs[2] | 1 |
| hits[2] | 2 |
+---------------+-------+
12 rows in set (0.00 sec)
</code></pre>

References:

<ul>
<li><a href="http://sphinxsearch.com/docs/1.10/sphinxql-show-meta.html" rel="nofollow">Sphinx: SHOW META syntax</a></li>
<li><a href="http://www.php.net/manual/en/sphinxclient.setlimits.php" rel="nofollow">SphinxClient::setLimits</a></li>
</ul>

blocks|key|3023990|text|SphinxClient:query不是在返回与您的请求相匹配的记录数量的数据吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3023991|据我所知，"+total“是指此请求返回的条目数(受SetLimit影响)，total_found是匹配查询的结果总数(不受SetLimit影响)。|3023992|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/sphinxclient.query.php^0|0|I|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Isn't <a href="http://www.php.net/manual/en/sphinxclient.query.php" rel="nofollow">SphinxClient:query</a> returning data about how many records matched your request?

"total" is the number of entries returned by this request (affected by SetLimit) and total_found is the total number of results matching query (not affected by SetLimit) as I understand.

blocks|key|3023994|text|SELECT+VARIABLE_NAME,+VARIABLE_VALUE
FROM+information_schema.GLOBAL_STATUS+WHERE
VARIABLE_NAME+LIKE+'SPHINX_TOTAL_FOUND';|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3023995|了解更多信息|unstyled|3023996|SELECT+VARIABLE_NAME,+VARIABLE_VALUE
FROM+information_schema.GLOBAL_STATUS+WHERE
VARIABLE_NAME+LIKE+'SPHINX_%25';|3023997|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>SELECT VARIABLE_NAME, VARIABLE_VALUE
FROM information_schema.GLOBAL_STATUS WHERE
VARIABLE_NAME LIKE 'SPHINX_TOTAL_FOUND';
</code></pre>

for more info

<pre><code>SELECT VARIABLE_NAME, VARIABLE_VALUE
FROM information_schema.GLOBAL_STATUS WHERE
VARIABLE_NAME LIKE 'SPHINX_%';
</code></pre>

I have to deal with queries that have lots of results, but I only show them in sets of 20-30 rows.

Then I use the SetLimits() method from the php API.

But I need to know what's the total number of results, to calculate the number of pages (or sets of results)

The only way I can do this right now is pulling all the results by setting the limit to 10000000 and see what is in the 'total' key of the array returned by sphinx, but this isn't good because I only need the count() number, I don't wan't sphinx to create a huge array with all the id's.

Performing a select..count() query in mysql won't work, because the indexed data in sphinx is always different.

Any ideas?

How to count results in sphinx?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我必须处理有很多结果的查询，但我只以20-30行为一组来显示它们。然后，我使用php API中的SetLimits()方法。但我需要知道结果总数是多少，才能计算页数(或结果集)我现在唯一能做到这一点的方法是通过将限制设置为10000000来提取所有结果，并查看sphinx返回的数组的'total‘键中有什么，但这并不好...

问如何在sphinx中计算结果？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在sphinx中计算结果？EN