Help with GraphQL query getByInfoHash

[felipemarinho97]

Anyone can please help me to build a O(1) query for getting info from a torrent using its info_hash?

With postgres I can do the query really fast:

bitmagnet=# select * from torrent_files where info_hash = '\x52a328e41360c37752e73f4e0c0fef05f8219ab8';
                 info_hash                  | index |        path        | extension |   size    |          created_at           |          updated_at
--------------------------------------------+-------+--------------------+-----------+-----------+-------------------------------+-------------------------------
 \x52a328e41360c37752e73f4e0c0fef05f8219ab8 |     0 | ktds-437.mp4       | mp4       | 988163823 | 2024-07-16 22:04:06.558036+00 | 2024-07-16 22:04:06.558036+00
 \x52a328e41360c37752e73f4e0c0fef05f8219ab8 |     1 | JAVTorrent.Biz.url | url       |        48 | 2024-07-16 22:04:06.558036+00 | 2024-07-16 22:04:06.558036+00
(2 rows)

bitmagnet=# select * from torrents where info_hash = '\x52a328e41360c37752e73f4e0c0fef05f8219ab8';
                 info_hash                  |             name             |   size    | private |          created_at           |          updated_at           | files_status | extension | files_count
--------------------------------------------+------------------------------+-----------+---------+-------------------------------+-------------------------------+--------------+-----------+-------------
 \x52a328e41360c37752e73f4e0c0fef05f8219ab8 | [javtorrent.biz]0820-ktds437 | 988163871 | f       | 2024-07-16 22:04:06.544326+00 | 2024-07-16 22:04:06.544326+00 | multi        |           |           2
(1 row)

Also from the UI https://bitmagnet.local/webui/torrents/permalink/fc61ecbc03cff212496fdd20e047c4d621285c38
answers really fast.

but my GraphQL query takes 10 minutes:

query GetTorrentMetadata($infoHashString: String!, $infoHashHash: Hash20!) {
  torrentContent {
    search(input: { queryString: $infoHashString, limit: 1 }) {
      items {
        infoHash
        title
        torrent {
          infoHash
          name
          size
          filesCount
          seeders
          leechers
          magnetUri
          createdAt
          updatedAt
        }
      }
    }
  }
  torrent {
    files(input: { infoHashes: [$infoHashHash], limit: 100 }) {
      totalCount
      items {
        index
        path
        size
        extension
        fileType
      }
    }
  }
}

[felipemarinho97]

After debugging the https://bitmagnet.local/webui/torrents/permalink/fc61ecbc03cff212496fdd20e047c4d621285c38
I was able to craft this query which is faster

		query TorrentMetadataAndFiles($contentInput: TorrentContentSearchQueryInput!, $filesInput: TorrentFilesQueryInput!) {
			torrentContent {
				search(input: $contentInput) {
					items {
						infoHash
						contentType
						title
						torrent {
							infoHash
							name
							size
							filesCount
							seeders
							leechers
							magnetUri
							createdAt
							updatedAt
						}
					}
				}
			}
			torrent {
				files(input: $filesInput) {
					items {
						infoHash
						index
						path
						size
						fileType
						createdAt
						updatedAt
					}
				}
			}
		}