Paths

Table of Contentst

Diffusion kolab 4e197faefdef

Improve performance of finding country code from an IP address
4e197faefdef
Actions

Description

Improve performance of finding country code from an IP address

Summary: Speed up the query from 0.17 sec. to 0.03 sec. Removed redundant indices.

Test Plan: ./phpunit

Reviewers: #hkccp_developers, mollekopf

Reviewed By: #hkccp_developers, mollekopf

Subscribers: #hkccp_developers

Differential Revision: https://git.kolab.org/D3674

Details

Provenance

machniak	Authored on Jul 14 2022, 1:32 PM
mollekopf	Committed on Sep 15 2022, 1:40 PM
mollekopf	Pushed on Sep 19 2022, 10:44 AM

Reviewer

Restricted Project

Differential Revision

D3674: Improve performance of finding country code from an IP address

Parents

rK462f24f37900: Changes for WOAT support

Branches

Unknown

Tags

Unknown

Event Timeline

Christian Mollekopf <mollekopf@apheleia-it.ch> committed rK4e197faefdef: Improve performance of finding country code from an IP address (authored by machniak).Sep 15 2022, 1:40 PM

Changes (10)

Path

Size

src/

app/

Console/

Commands/

Data/

Import/

Providers/

AppServiceProvider.php

database/

migrations/

2022_07_07_100000_ip_nets_optimization.php

tests/

Feature/

Controller/

AuthTest.php

NGINXTest.php

PasswordResetTest.php

Unit/

UtilsTest.php

rK4e197faefdef

View Options

src/app/Console/Commands/Data/Import/IP4NetsCommand.php

View Options

src/app/Console/Commands/Data/Import/IP6NetsCommand.php

View Options

src/app/IP4Net.php

View Options

src/app/IP6Net.php

View Options

src/app/Providers/AppServiceProvider.php

View Options

src/database/migrations/2022_07_07_100000_ip_nets_optimization.php

View Options

src/tests/Feature/Controller/AuthTest.php

View Options

src/tests/Feature/Controller/NGINXTest.php

View Options

src/tests/Feature/Controller/PasswordResetTest.php

View Options

src/tests/Unit/UtilsTest.php

Improve performance of finding country code from an IP address4e197faefdefActions

Description

Details

Event Timeline

Changes (10)

rK4e197faefdef

src/app/Console/Commands/Data/Import/IP4NetsCommand.php

src/app/Console/Commands/Data/Import/IP6NetsCommand.php

src/app/IP4Net.php

src/app/IP6Net.php

src/app/Providers/AppServiceProvider.php

src/database/migrations/2022_07_07_100000_ip_nets_optimization.php

src/tests/Feature/Controller/AuthTest.php

src/tests/Feature/Controller/NGINXTest.php

src/tests/Feature/Controller/PasswordResetTest.php

src/tests/Unit/UtilsTest.php

Improve performance of finding country code from an IP address
4e197faefdef
Actions