server icon indicating copy to clipboard operation
server copied to clipboard

Add batch methods in user backends

Open CarlSchwan opened this issue 3 years ago • 2 comments

This allows for faster group search with significantly less DB traffic

Splited from #32201 for easier review

CarlSchwan avatar Jun 17 '22 09:06 CarlSchwan

Possible performance regression detected

Show Output
2 queries added

= /remote.php/dav/files/test
= /remote.php/dav/files/test/test.txt
≠ /remote.php/dav/files/test/many_files with 1 queries added
  + UPDATE "oc_preferences" SET "configvalue" = :dcValue1 WHERE ("userid" = :dcValue2) AND ("appid" = :dcValue3) AND ("configkey" = :dcValue4)
≠ /remote.php/dav/files/test/new_file.txt with 1 queries added
  + UPDATE "oc_preferences" SET "configvalue" = :dcValue1 WHERE ("userid" = :dcValue2) AND ("appid" = :dcValue3) AND ("configkey" = :dcValue4)
= /remote.php/dav/files/test/new_file.txt

github-actions[bot] avatar Jul 25 '22 09:07 github-actions[bot]

Failing tests are related

CarlSchwan avatar Aug 02 '22 22:08 CarlSchwan

Discussed this internally, should be moved to a new interface.

come-nc avatar May 09 '23 15:05 come-nc

Discussed this internally, should be moved to a new interface.

Added the interface, rebased, fixed tests and psalm reports.

come-nc avatar Sep 05 '23 13:09 come-nc