You're mixing up I/O-based pricing with rows-based pricing. Aurora is priced based on I/O operations, with 16KB pages: https://aws.amazon.com/rds/aurora/faqs/
If you're doing a range scan query and your rows are reasonably-sized, you can conceivably get tens of rows to maybe even a few hundred rows per single I/O operation. Or even 0 I/O operations if the pages are already in memory in the buffer pool cache.
Planetscale prices based on rows.. And scanning a few FAQs I don't see anything about cached rows being free, but maybe i missed it.
Comments
You're mixing up I/O-based pricing with rows-based pricing. Aurora is priced based on I/O operations, with 16KB pages: https://aws.amazon.com/rds/aurora/faqs/
If you're doing a range scan query and your rows are reasonably-sized, you can conceivably get tens of rows to maybe even a few hundred rows per single I/O operation. Or even 0 I/O operations if the pages are already in memory in the buffer pool cache.
Planetscale prices based on rows.. And scanning a few FAQs I don't see anything about cached rows being free, but maybe i missed it.