[incubator-baremaps] branch 544-optimize-the-index-to-search-by-ip_start-and-ip_end updated: Create a new index that includes both ip_start and ip_loc

[adrabble]

This is an automated email from the ASF dual-hosted git repository.

adrabble pushed a commit to branch 
544-optimize-the-index-to-search-by-ip_start-and-ip_end
in repository https://gitbox.apache.org/repos/asf/incubator-baremaps.git


The following commit(s) were added to 
refs/heads/544-optimize-the-index-to-search-by-ip_start-and-ip_end by this push:
     new 59796bdd Create a new index that includes both ip_start and ip_loc
59796bdd is described below

commit 59796bdd7c8c49164972c9b7b8e675b90cd7f7e5
Author: Antoine Drabble <antoine.drab...@gmail.com>
AuthorDate: Wed Nov 30 14:13:10 2022 +0100

    Create a new index that includes both ip_start and ip_loc
---
 baremaps-core/src/main/resources/iploc_init.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/baremaps-core/src/main/resources/iploc_init.sql 
b/baremaps-core/src/main/resources/iploc_init.sql
index 0becaa78..6ad3a943 100644
--- a/baremaps-core/src/main/resources/iploc_init.sql
+++ b/baremaps-core/src/main/resources/iploc_init.sql
@@ -9,5 +9,4 @@ CREATE TABLE IF NOT EXISTS inetnum_locations (
     network text,
     country text
 );
-CREATE INDEX ip_start_index ON inetnum_locations (ip_start);
-CREATE INDEX ip_end_index ON inetnum_locations (ip_end);
\ No newline at end of file
+CREATE INDEX inetnum_locations_ips ON inetnum_locations (ip_start,ip_end);
\ No newline at end of file