B4J Question About DB Connection Pooling

vfafou

Well-Known Member
Licensed User
Longtime User
Hello!
I'm trying to understand how to correctly implement connection pooling inside Custom WebSocket Push Framework.
During reading several posts, I opened:
https://www.b4x.com/android/forum/t...n-device-desktop-and-web-reports.37254/page-3
and now I'm totally confused!
Which is the best way to connect to a database for many concurrent devices requests? Using the above tutorial, making one connection per device thread or maintain one public connection for all devices?
And all this is needed to be as real-time as possible!
By the way, any help about correctly building connection pooling is highly appreciated!
Thank you in advance!
 

vfafou

Well-Known Member
Licensed User
Longtime User
Hello Erel!
I'm using two Databases: one MySQL 4.0 Instance and one MariaDB 10.0 Instance, installed on different server machines.
The MariaDB Instance is the Web Server Database and MySQL 4.0 is my old VB6 application's RDBMS.
Testing whole system, I decided to connect web socket server to the old database in order to have faster response time rather than my previous case that I was sending messages from the web server to socket server which was forwarding the messages to my old VB6 application for executing several Database Jobs.
I've already built the connection pooling and I think I have much better response than my previous approach.
Great B4X tools!!!
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…