SQL table reading/writing ...

Ritchie

Hi,

is "QSqlQuery" the fastest method to read and write a small amount of data into a SQL database.

I will read some information on a sql database and will send back the results via ssl connection to a connected client. Also I will write sensor datas from the client into the database.

Is QSQLQuery the best way for this ?

Best regards
R.

VRonin

It's the only way to do it through the Qt framework.

JonB

@Ritchie

Be aware that your "bottleneck" will not be the size of the "small" data packets you read/write but rather the number of distinct calls to SQL you issue. If there is anything you can do to "group"/"amalgamate" the data to reduce the number of calls that will have the biggest performance gain, though your logic/requirements may not allow you to do this.

Ritchie

Thanks for this Information.
Best regards
R.