If you are querying WowTokenCreated on the Index Supply free plan, please reach out to me as I have a query suggestion for you. It will bring your cold query latency from a couple of seconds down to ~150ms.

here is the faster query:

If you are querying WowTokenCreated on the Index Supply free plan, please reach out to me as I have a query suggestion for you. It will bring your cold query latency from a couple of seconds down to ~150ms.

here is the faster query: https://tinyurl.com/wowtoken-with-addr

Indexing Ethereum https://indexsupply.com

What was the slow query? Interested in comparing

Engineer @ Syndicate, prev: Rainbow, Foundation & Cloudflare /poetic-web, builds caststorage.com

It's the same query without the address. If the underlying data is cached (in pg's shared buffers or the OS's page cache) (it is as of this cast) then there will be no difference.

This particular query is on the slower side simply because of how many rows are being returned. I'm not saying that queries without addresses will always have a penalty, but in this particular case, adding the address predicate will increase cache hit rate because fewer file system pages are needed. And when it's not cached it will be quicker for the same reason.

Oh that’s good to know. I’m honestly surprised it would have worked at all without an address. I would have assumed the query space would be too vast tbh.

We've got plenty of indexes around these parts ;)