]> git.ktnx.net Git - mpd-feeder.git/commit
projects / mpd-feeder.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: eeea137) | patch
rework DB update using COPY and a PostgreSQL function for maximum speed
authorDamyan Ivanov <dmn@debian.org>
Mon, 15 Nov 2021 06:12:09 +0000 (06:12 +0000)
committerDamyan Ivanov <dmn@debian.org>
Mon, 15 Nov 2021 06:12:09 +0000 (06:12 +0000)
commit77d28a4deff0003254af5bd402cdaa4ad5470b30
tree894291c18a6772bb86941ce4e4fd3476af6896c3tree | snapshot
parenteeea137fa23911f368ae99027e4b0543da213180commit | diff
rework DB update using COPY and a PostgreSQL function for maximum speed

COPY is the most effective data loading mechanism, and using a function
reduces the number of requests to just one
lib/App/MPD/Feeder.pm diff | blob | history
lib/App/MPD/Feeder/DB.pm diff | blob | history
sql/pgsql/init.sql diff | blob | history
mpd-feeder -- keep MPD busy, with emphasys on diversity