Android Question Seeking Guidance on Optimizing Database Access for Scaling B4X App

[amarnath]

I'm currently using B4J with JdbcSQL to connect directly to a remote MySQL database:

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.

 

[aeric]

For jRDC2, please check the following threads:
1. https://www.b4x.com/android/forum/threads/project-template-jrdc2-server.165712/
2. https://www.b4x.com/android/forum/threads/project-template-jrdc2-client-b4x-b4j-b4a-b4i.166069/
3. https://www.b4x.com/android/forum/threads/jrdc2-server-with-login-session.166903/

 

[hibrid0]

Check this template ready to use from the master Aeric. Why you don't use the search function?
Have a lot of examples.

[Project Template] jRDC2 Server

Version: 3.10 Project template based on jRDC2 version 2.23 with sample database. GitHub: https://github.com/pyhoon/jrdc2-server-template-b4j Template: JRDC Server (3.10).b4xtemplate Supported databases: SQLite MySQL MS SQL Firebird Postgresql DBF Depends on: JavaObject jRandomAccessFile...

www.b4x.com

And this is a mod for Jrdc2 for multiple dbs, json answers and more performance.

jRDC2 MultiDB Server (JSON, HikariCP)

1. Introduction and Architecture This project is a modified version of the original jRDC2 Server. The multi-database support is based on Erel's JDC2 Multiple Database modification, and includes three main structural changes: HikariCP Migration: The connection pool was migrated from C3P0 to...

www.b4x.com

 

[amarnath]

Check this template ready to use from the master Aeric.

Thank you for your patience.
I’ve decided to fully switch to jRDC2—since I have a VPS and want to stay 100% in the B4X ecosystem.

This will help me avoid common pitfalls and move forward smoothly.


Thanks again for all your support!