PDA

View Full Version : QSqlDatabase PSQL connection options



leknarf
17th March 2010, 17:06
Hi all,

Is there a buffer size or similar optimization parameter that can be set for QSqlDatabase PSQL connections? The docs refer to PostgreSQL "options" without specifying what they may be. (*)

I have a PG database cluster of about 7MB, spread over a couple dozen tables. Locally, it takes about 6 seconds to launch my app, loading the model data into my forms.

When I pull an identical data-set from a remote location, my application launch time increases to over 60 seconds. Yet resource utilization on the remote server is minuscule.

For comparison, I'm able to download the results of a 21MB SELECT statement in less than 8 seconds via cmd-line psql. That's an order of magnitude more data in an order of magnitude less time!

Suggestions greatly appreciated!
Scott



(*) I already have the "requiressl" option flag set, as per the docs. eg:

// PostgreSQL connection
db.setConnectOptions("requiressl=1"); // enable PostgreSQL SSL connections
if (!db.open()) {
db.setConnectOptions(); // clear options
...