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
...
Bookmarks