Ryan J. Shaw
@rjs
Solana is... interesting Dune data has weird gaps in data and timeouts when you try to lookup a tx, nothing works like EVM, it's just all so strange... and yet look at those MCs...
9 replies
1 recast
19 reactions
Mats
@mats
Data is so large that you can’t generally just look for a hash - need to provide more guidance to the query engine or use a tool that’s built for oltp not olap
1 reply
0 recast
1 reaction
Ryan J. Shaw
@rjs
yeah, doing select * from solana.transactions where id = 'xxx' timed out after 30min with medium 🤯 adding in block_slot was nearly instant, though, luckily I have that on hand
0 reply
0 recast
1 reaction