Below is the response times of different databases in AWS

Database Typical Response Time Usage
Amazon DynamoDB milliseconds to single-digit seconds NoSQL DB
Amazon Redshift seconds to minutes Data Warehouse
Amazon RDS (MySQL, PostgreSQL, SQL Server, Oracle) milliseconds to seconds SQL DB
Amazon Aurora milliseconds to seconds Faster than RDS supports Mysql and PostgreSQL only
Amazon Neptune milliseconds to seconds Used for social Media
Amazon DocumentDB milliseconds to seconds NoSQL Document DB (Compatabile with MongoDB)
Amazon Keyspaces (for Apache Cassandra) milliseconds to seconds Used for building Single-digit-millisecond latency apps