GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Embed Notice

HTML Code

Corresponding Notice

  1. Embed this notice
    heluecht (heluecht@pirati.ca)'s status on Tuesday, 27-Dec-2022 16:44:55 JSTheluechtheluecht
    in reply to
    • heluecht
    • hypolite
    @hypolite This sounds like coding with one hand tied on the back and then having the need to invent some workaround to counter the self caused limitations.

    So the easy task of setting the status will now consist of:
    - fetching all report fields (although we don't need the content for our task)
    - fetching all associated side table fields (the uri-ids) (although this is of no interest here)
    - processing the fields
    - returning the content
    - changing one value (the status)
    - storing all fields in the report table
    - delete all table entries for that report in the side table with the uri-ids
    - insert all table entries again, although we haven't change anything there

    And this process will even getting worse, when we have the need to set the status for a whole bunch of reports (when for example 10 people report the same, then we should be able to easily close 9 reports). In that case - instead of issuing a single update command with the array of the report ids - we had to execute the above steps in some loop. This will slow down the whole process and will increase the database load as well.

    I understand the reason why to work with class variables instead of associated arrays when handling with fetched data. But I don't see a reason why to limit ourselves upon updating as well.
    In conversationTuesday, 27-Dec-2022 16:44:55 JST from pirati.capermalink
  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.