I'm currently using B4J with JdbcSQL to connect directly to a remote MySQL database:
However, saving data takes over 30 seconds—too slow for my growing user base (projected >1000 clients).
Would switching to RDC (Remote Database Connector) or using a custom API (e.g., api.php) significantly improve performance and scalability?
Given your expertise, which approach would you recommend for a high-performance B4X mobile app serving thousands of users?
Thank you for your time and guidance.
B4X:
Public mysql As JdbcSQL
Public driver As String = "com.mysql.jdbc.Driver"
Public jdbcUrl As String = "jdbc:mysql://207.1*.2*.2*:3306/amarnq4g_dairy?useSSL=False&characterEncoding=utf8"
Public Username As String = "amarg_amarnath"
Public Password As String = "Amarnath@@1234"However, saving data takes over 30 seconds—too slow for my growing user base (projected >1000 clients).
Would switching to RDC (Remote Database Connector) or using a custom API (e.g., api.php) significantly improve performance and scalability?
Given your expertise, which approach would you recommend for a high-performance B4X mobile app serving thousands of users?
Thank you for your time and guidance.