)]}'
{
  "commit": "3c2272e378f77057ce47a4089f2eb7b49fb53ecd",
  "tree": "a8b1498af6f3e15771eab90f5fcabf2398b20d18",
  "parents": [
    "a5b66bbcd75056e7dc0a10516367efbe013319f6"
  ],
  "author": {
    "name": "Saša Živkov",
    "email": "sasa.zivkov@sap.com",
    "time": "Fri Mar 22 14:58:30 2024 +0100"
  },
  "committer": {
    "name": "Matthias Sohn",
    "email": "matthias.sohn@sap.com",
    "time": "Tue Apr 02 12:26:22 2024 +0200"
  },
  "message": "Add indexes to the H2 cache databases\n\nMany owners of large Gerrit sites complain about the H2 performance but\nmaybe it is also the lack of indexes which contributes to the bad\nperformance. Looking at the SELECT statements we need indexes on\n(version, k) fields and also on the (accessed) field. Without these\nindexes, the database will likely have to perform full table scans which\ncan be quite expensive for large site with millions of changes.\n\nRelease-Notes: Add indexes to the H2 cache databases\nChange-Id: I6d67878b81d46cd4b342ba9480e31d3af4b5ce40\n",
  "tree_diff": [
    {
      "type": "modify",
      "old_id": "ad464837d90272d94ad4b025c4fa01cb7baa3504",
      "old_mode": 33188,
      "old_path": "java/com/google/gerrit/server/cache/h2/H2CacheImpl.java",
      "new_id": "3a732d11689b86bcc531223c2850d37aa16f17c0",
      "new_mode": 33188,
      "new_path": "java/com/google/gerrit/server/cache/h2/H2CacheImpl.java"
    }
  ]
}