Databases
StackOverflow2013
Postsdbo
POConnection Pooling in a small application
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConnection Pooling in a small application
    text
    copied!<p>I've got a few simple questions about connection pooling and best practices. I'm planning and writing a small application which relies on a MySQL database. In this application I use modules and plug-ins which can create connections. The application has direct access to the MySQL database and it will probably be the only client connecting to the database.</p> <p><strong>Here are my first questions: Will connection pooling make sense? Is it irrelevant or should I disable it? What are your experiences?</strong></p> <p>On the other hand in my company we develop another software which has one MySQL database server and many clients. Every client can open multiple windows in which multiple connections can be active. There is a good chance that this software will be using the basic concept of my new application. The clients connect directly with the database. So I guess it would make a lot of sense to write a server application which handles the pooling and organizes the connections, am I right? How much sense would it make to let every client use it's own connection pool? We're talking about 1-50 clients with 1-10 connections.</p> <p><strong>Do you think it's the best to write a small server application to handle the connection pooling?</strong></p> <p>I'm asking because I don't really know when connection pooling makes sense and when not and how to handle it with small and medium sized client applications. I'm looking for some input of your experiences. :) I hope the questions is not to awkward. ^^</p> <p>Greetings,<br> Simon</p> <p>P.S.: It's a windows based application. Not a web service.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload