1 回答
- 最新
- 投票最多
- 评论最多
1
Yes, queries with with inequality conditions are not recommended because they don't scale well when the amount of data in table grows. There are currently two workarounds to overcome this problem:
- Depending on your application architecture, you may consider using Streaming feature of Amazon QLDB to process transactionRegistry records once they created or updated in the table. Steaming sends journal updates to Amazon Kinesis, which can trigger AWS Lambda function to filter out the document and call API of another component or just store it somewhere else for further processing.
- Instead of an id, you may capture the timestamp of the last processed transactionRequest record. Then the batch process can trigger Export Journal feature to export Amazon QLDB journal to Amazon S3 starting from that timestamp and then process exported files.
已回答 2 年前
相关内容
- AWS 官方已更新 1 年前
- AWS 官方已更新 7 个月前
- AWS 官方已更新 1 年前
Thank you. Do you have any information if such features will be added in future (near future)?