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
    Curtis Rock, SkD (curtis@social.teci.world)'s status on Thursday, 11-Apr-2024 05:34:42 JSTCurtis Rock, SkDCurtis Rock, SkD
    in reply to
    • Alex Gleason

    @alex https://sqlite-users.sqlite.narkive.com/rUeC9GQR/slow-query-after-reboot

    To speedup the initial access, you can:

    • read the entire file once before you start your query
    • run the following query (once) select count(last_column) from big_table; this will touch each record in a kind of optimal order
    In conversationabout 10 months ago from social.teci.worldpermalink

    Attachments


  • 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.