If those million items need to be read from different servers -- as they might well, in a distributed database -- it's definitely not just a few ms of computing power.
For reference, reading a million items of up to 1 kB each costs $0.125 with on-demand dynamodb.
> For reference, reading a million items of up to 1 kB each costs $0.125 with on-demand dynamodb.
Is that the same counting method as PlanetScale's "row read"? That is, `select title from posts order by title limit 10` on a table with 10 million rows and no index on `title` would cost $1.25 per query?
DynamoDB doesn't have SQL queries; but yes, if you're performing an operation which reads 10 million items from ddb it will be absurdly expensive. It will also take an absurdly long time; by default ddb is limited to 40k read request units (= 80k eventually consistent reads of up to 1 kB) per second. Being so slow would probably make users realize they're doing something wrong.
For reference, reading a million items of up to 1 kB each costs $0.125 with on-demand dynamodb.