Hacker News new | ask | show | jobs
by cperciva 1685 days ago
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.

1 comments

> 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.