]> git.ipfire.org Git - people/ms/libloc.git/commit
projects / people / ms / libloc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7177031) | patch
location-importer: Speed up exporting the database
authorMichael Tremer <michael.tremer@ipfire.org>
Fri, 15 May 2020 09:06:22 +0000 (09:06 +0000)
committerMichael Tremer <michael.tremer@ipfire.org>
Fri, 15 May 2020 09:06:22 +0000 (09:06 +0000)
commit8e8555bbbf849a94d46e88e240f936021e0b48fc
treeb484864115dbf2441bdc79e729ee33ea2c2fb994tree | snapshot
parent7177031fa551c7b63afc6d13ac731394ba228f8dcommit | diff
location-importer: Speed up exporting the database

This optimisation returns the same result, but in about
one fifteenth of the time than the previous version of
the query.

This can also be parallelised by PostgreSQL so that more
CPU cores will decrease the time it takes to generate
the network list.

On my system this went down from 75 to 5 minutes.

Signed-off-by: Michael Tremer <michael.tremer@ipfire.org>
src/python/location-importer.in diff | blob | blame | history
A library to determine the location of someone on the Internet