Paths

Table of Contentst

Diffusion kolab e140111896b0

Improve performance of finding country code from an IP address
e140111896b0Unpublished
Actions

Unpublished Commit · Learn More

Not On Permanent Ref: This commit is not an ancestor of any permanent ref.

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 1 2022, 11:59 AM
mollekopf	Pushed on Sep 1 2022, 3:07 PM

Reviewer

Restricted Project

Differential Revision

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

Parents

rKdb2ed29a04d4: Allow unauthenticated requests for CalDAV/CardDAV/ActiveSync

Branches

Unknown

Tags

Unknown

Event Timeline

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

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

rKe140111896b0

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 addresse140111896b0UnpublishedActions

Unpublished Commit · Learn More

Description

Details

Event Timeline

Changes (10)

rKe140111896b0

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
e140111896b0Unpublished
Actions