Slow query response when connecting to Alibaba Cloud RDS (high perceived latency), other clients work fine

[kevenblog]

What happened?

Problem Description

When using TablePro to connect to Alibaba Cloud RDS for MySQL and executing simple queries with a small amount of data, the displayed "query execution time" is very short (e.g., 504ms), but the actual time from clicking "Execute" to seeing the result table fully rendered takes several seconds (with visible spinning). Queries against a local database are fast. Other database clients (e.g., DataGrip, Navicat) connecting to the same Alibaba Cloud database do not have this problem.

Key Characteristics

• The query returns a very small amount of data, only a few hundred records.
• Other database clients connecting to the same Alibaba Cloud RDS respond quickly (perceived time is close to the displayed execution time).
• Network latency is normal (ping < 50ms), no packet loss.

Steps to Reproduce

1. Create a new connection to Alibaba Cloud RDS for MySQL in TablePro.
2. Execute a simple query like SELECT * FROM table LIMIT 500;.
3. Observe: TablePro shows an execution time of about 500ms at the bottom, but it actually takes 3-5 seconds from clicking "Execute" to the table being fully displayed.
4. Execute the same SQL in another client (e.g., DataGrip). The total response time is close to the displayed execution time (finished within 1 second).

Expected Result

The total response time should be roughly consistent with the displayed execution time (plus a small amount of network transmission and rendering overhead). There should not be an extra delay of several seconds.

Actual Result

The total response time is much longer than the displayed execution time. There is a significant additional delay.

Environment Information

• TablePro version: 0.48.0 (94)

Additional Information

• The amount of data is only a few hundred rows, ruling out large-data rendering issues.
• No such problem with local database.
• Ping to Alibaba Cloud RDS latency is stable with no packet loss.
• Already tried disabling SSL/TLS encryption, the problem persists.

---

Steps to reproduce

No response

Expected behavior

No response

Database type

MySQL / MariaDB

TablePro version

0.48.0

macOS version & chip

14.8.7

Screenshots / Logs

No response