[GitHub] [incubator-devlake] likyh commented on pull request #2619: feat: graphql POC in github

[GitBox <gi...@apache.org>]

likyh commented on PR #2619:
URL: https://github.com/apache/incubator-devlake/pull/2619#issuecomment-1197636273

   the comparison in different ways:
   
   | Way                     | Restful                                                      | Graphql Rough version(now)                                   | Graphql+Restful                                              |
   | ----------------------- | ------------------------------------------------------------ | ------------------------------------------------------------ | ------------------------------------------------------------ |
   | Theoretical Request Num | Num(PR) * 2 +<br />Num(account) * 2 +<br />Num(PR+issue+comment+issueEvent+reviewComment+milestone) / 100 + 1 | Num(PR+issue) / 100 + 2<br /><br />Not include: comment/<br />issueEvent/milestone/reviewComment | Num(PR+issue+account+comment+<br />issueEvent+milestone) / 100 + 2 |
   | Example: ants           | Requests: 55*(PR)* * 2 + 218*(account)* * 2 + [55*(PR)* + 180*(issue)* + 650*(comment)* + 1400*(issueEvent)* + 104*(reviewComment)* + 1*(milestone)*] / 100 + 1 ≈ 560<br />Time: **About takes 560s for 1 token**<br />RateLimit: 560/5000 requests | Requests:  [55*(PR)* + 180*(issue)*] / 100 + 2 ≈ 5<br />Time: About 10s<br />RateLimit: About 208/5000 points | Requests:  [55*(PR)* + 180*(issue)* + 218*(account)* + 650*(comment)* + 1400(issueEvent) + 1*(milestone)*] / 100 + 2 ≈ 30<br />Time: **About 30s**<br />RateLimit: 13/5000 points + <br />About 23/5000 requests |
   | Example: devlake        | Requests: 1315*(PR)* * 2 + about 100*(account)* * 2 + [1315*(PR)* + 1317*(issue)* + 2950*(comment)* + 19800*(issueEvent)* + 1350*(reviewComment)* + 9*(milestone)*] / 100 + 1 ≈ 3100<br />Time: **About takes 10min for 6 token**<br />RateLimit: 3100/5000 requests | Requests:  [1315*(PR)* + 1317*(issue)*] / 100 + 2 ≈ 30<br />Time: About 3min<br />RateLimit: About 2500/5000 points | Requests:  [1315*(PR)* + 1317*(issue)* + about 100*(account)* + 2950*(comment)* + 19800(issueEvent) + 9*(milestone)*] / 100 + 2 ≈ 260<br />Time: **About 5min for 1 token**<br />RateLimit: 115/5000 points + <br />About 229/5000 requests |
   | Example: clickhouse     | Requests: 27099*(PR)* * 2 + about 3000*(account)* * 2 + [27099*(PR)* + 12372*(issue)* + 40000*(comment)* + 40000*(issueEvent)* + 33200*(reviewComment)* + ...] / 100 + 1 ≈ 61000<br />Time: **About takes 18h for 10 token**<br />RateLimit: -/5000 requests | -                                                            | Requests:  [27099*(PR)* + 12372*(issue)* + about 3000*(account)* + 40000*(comment)* + 40000(issueEvent) + ...] / 100 + 2 ≈ 1200<br />Time: **About 15min for 1 token**<br />RateLimit: 1800/5000 points + <br />About 800/5000 requests |
   
   
   


-- 
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: commits-unsubscribe@devlake.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org