You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@baremaps.apache.org by GitBox <gi...@apache.org> on 2022/11/30 13:18:47 UTC

[GitHub] [incubator-baremaps] Drabble opened a new pull request, #545: Create a new index that includes both ip_start and ip_end

Drabble opened a new pull request, #545:
URL: https://github.com/apache/incubator-baremaps/pull/545

   Following up on #544 I have create a new index to replace the previous ones. It will index on ip_start and then on ip_end. This will greatly increase the query time to find IPs in-between ip_start and ip_end.
   
   In my tests, I have found that I go from 6.5 seconds to query an IP by range to about 0.5 seconds.
   
   Using `EXPLAIN QUERY PLAN`, we can see that we use the new index `SEARCH inetnum_locations USING INDEX inetnum_locations_ips (ip_start>?)`. 
   
   


-- 
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@baremaps.apache.org

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

[GitHub] [incubator-baremaps] Drabble merged pull request #545: Create a new index that includes both ip_start and ip_end

Posted by GitBox <gi...@apache.org>.

Drabble merged PR #545:
URL: https://github.com/apache/incubator-baremaps/pull/545


-- 
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@baremaps.apache.org

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

[GitHub] [incubator-baremaps] sonarcloud[bot] commented on pull request #545: Create a new index that includes both ip_start and ip_end

Posted by GitBox <gi...@apache.org>.

sonarcloud[bot] commented on PR #545:
URL: https://github.com/apache/incubator-baremaps/pull/545#issuecomment-1332150960

   Kudos, SonarCloud Quality Gate passed!&nbsp; &nbsp; [![Quality Gate passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/passed-16px.png 'Quality Gate passed')](https://sonarcloud.io/dashboard?id=baremaps_baremaps&pullRequest=545)
   
   [![Bug](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/bug-16px.png 'Bug')](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=BUG) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=BUG) [0 Bugs](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=BUG)  
   [![Vulnerability](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/vulnerability-16px.png 'Vulnerability')](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=VULNERABILITY) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=VULNERABILITY) [0 Vulnerabilities](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=VULNERABILITY)  
   [![Security Hotspot](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/security_hotspot-16px.png 'Security Hotspot')](https://sonarcloud.io/project/security_hotspots?id=baremaps_baremaps&pullRequest=545&resolved=false&types=SECURITY_HOTSPOT) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/security_hotspots?id=baremaps_baremaps&pullRequest=545&resolved=false&types=SECURITY_HOTSPOT) [0 Security Hotspots](https://sonarcloud.io/project/security_hotspots?id=baremaps_baremaps&pullRequest=545&resolved=false&types=SECURITY_HOTSPOT)  
   [![Code Smell](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/common/code_smell-16px.png 'Code Smell')](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=CODE_SMELL) [![A](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/RatingBadge/A-16px.png 'A')](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=CODE_SMELL) [0 Code Smells](https://sonarcloud.io/project/issues?id=baremaps_baremaps&pullRequest=545&resolved=false&types=CODE_SMELL)
   
   [![No Coverage information](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/CoverageChart/NoCoverageInfo-16px.png 'No Coverage information')](https://sonarcloud.io/component_measures?id=baremaps_baremaps&pullRequest=545&metric=coverage&view=list) No Coverage information  
   [![No Duplication information](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/Duplications/NoDuplicationInfo-16px.png 'No Duplication information')](https://sonarcloud.io/component_measures?id=baremaps_baremaps&pullRequest=545&metric=duplicated_lines_density&view=list) No Duplication information
   
   


-- 
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@baremaps.apache.org

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