Re: [I] 查询结果80w的限制问题 [incubator-hugegraph]

Tue, 16 Apr 2024 02:53:20 -0700 


zhuiyi1 commented on issue #586:
URL: 
https://github.com/apache/incubator-hugegraph/issues/586#issuecomment-2058692821

   > > > > 
![image](https://user-images.githubusercontent.com/34566983/149049401-b057fdc1-458b-4add-9d6c-78e2a8b0f068.png)
 gremlin 超过 80W 这问题治不了了是嘛
   > > > 
   > > > 
   > > > @megodlike 方法有不少, 首先你的写法可以改一下. `g.V().limit(1000).out()` 提前限制, 
因为你扫一遍所有点其实也没有多少意义, 当然后续这种语法我们也可以做优化, 把它提前限制. 然后包括当前 issue 里写到的, 使用 page 
分页也可以查询, 跟 mysql 类似, 一般 db 也不会让你扫全表的 (不过后续我们可以让用户自行决定)
   > > > 另外, 80w 的限制也可以代码里调整一下, 我们后续可以提供一个参数供大家自己选择.
   > > 
   > > 
   > > @imbajin 大佬zai在启动服务时报错 Too many records(must <= 800000) for the query: 
`Query * from VERTEX` 
![1713259283117](https://private-user-images.githubusercontent.com/100415085/322785205-a666495c-a4ac-417d-a6dc-64f90b346624.jpg?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTMyNTk4NDYsIm5iZiI6MTcxMzI1OTU0NiwicGF0aCI6Ii8xMDA0MTUwODUvMzIyNzg1MjA1LWE2NjY0OTVjLWE0YWMtNDE3ZC1hNmRjLTY0ZjkwYjM0NjYyNC5qcGc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNDE2JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDQxNlQwOTI1NDZaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02MTQ1Yzk0OTE5NmNiZTFhODExNjc1OGRhMmZhNWNiNjA5NWZhOWNjODAxZTBkZGI5YjIzODU1YTVhMWQ4YWY5JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.3HSZs2_y9UVmVBhJHZWBv5Ic6t8BzWYeEX5_lK0r0js)
   > 
   > @zhuiyi1 maybe try it first:
   > 
   > <img alt="image" width="725" 
src="https://private-user-images.githubusercontent.com/17706099/322787594-d488aabd-2e7e-412d-8ba8-2bca445909dc.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTMyNjA2NDEsIm5iZiI6MTcxMzI2MDM0MSwicGF0aCI6Ii8xNzcwNjA5OS8zMjI3ODc1OTQtZDQ4OGFhYmQtMmU3ZS00MTJkLThiYTgtMmJjYTQ0NTkwOWRjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA0MTYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNDE2VDA5MzkwMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTJiZmVmMTU3ZGE3ODM5MGFhM2JmZjg3YTQ3ODU3NjQ3MzgxYjdmN2Q3ZDA2YmZhZGMyNDc5YzJkNDdiNTJiZjAmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.Kalk9e9ePt4LPXopZMMdautVc_wObbzbNpgC-5yg8Jg";>
   > And u could also build index(IndexLabel) to what u want to search (on 
Vertex/Edge)
   
   @imbajin 大佬是这样的  现在服务器中有100多玩的节点数据，是在重启服务的时候报的错，还没有进行查询的操作呢，有没有办法改源码或者配置文件 
能让服务正常起来呢？


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to