user2897: As a developer, I'd like to have a service that retrieves the information of a stake pool based on its ticker (or all the stake pools with that ticker, I know there can be duplicates).
I'm thinking that with graphql I need to query first the list of stakePools (which is huge) and then filter that by ticker, which is inside the metadata of the pool.
Is there a way to do this in a more performing way or a service already solving this for me?

user5926: The list of stake pools should only be a couple of thousand which is tiny in comparison to number of blocks or even worse the number of transactions.
It can be done with a relatively simple SQL query on the database maintained by cardano-db-sync.

2897: <p>As a developer, I'd like to have a service that retrieves the information of a stake pool based on its ticker (or all the stake pools with that ticker, I know there can be duplicates).</p>
<p>I'm thinking that with <code>graphql</code> I need to query first the list of <code>stakePools</code> (which is huge) and then filter that by ticker, which is inside the <code>metadata</code> of the pool.</p>
<p>Is there a way to do this in a more performing way or a service already solving this for me?</p>
 5926: <p>The list of stake pools should only be a couple of thousand which is tiny in comparison to number of blocks or even worse the number of transactions.</p>
<p>It can be done with a relatively simple SQL query on the database maintained by <code>cardano-db-sync</code>.</p>
