Should I Use Single Connection or Multiple Connections with QSqlDatabase

Question

I have dependent and independent classes, I need to create database connections in these classes. As I understand from Qt documentation, if I create connections in default way, all of them use same connection.

Should I create different database connections for different classes, or should I use same database connection. What are pros and cons? Thanks.

Not a Qt/MySQL specialist, but in general. Multiple connections == multiple sessions == multiple outstanding transactions in the DB (plus whatever resource overhead that has). If you do not need multiple parallel transactions, then you do not need multiple connections. — Dummy00001
– Dummy00001, Commented Sep 15, 2010 at 12:06

Michael Scott Shappe · Accepted Answer · 2010-09-15 16:08:59Z

2

I'm not sure why @Dummy00001 logged his response as a comment rather than an answer, but I concur with him. If you aren't going to be working with the database in a parallel fashion, you don't need multiple connections, and they will, in fact, be wasteful of resources both in your client library and on the server.

answered Sep 15, 2010 at 16:08

Michael Scott Shappe

3601 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Should I Use Single Connection or Multiple Connections with QSqlDatabase

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related