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 |