As per Microsoft Learn, SingleRow
- The query is expected to return a single row of the first result set.
- If your SQL statement is expected to return only a single row, specifying SingleRow can also improve application performance.
Of course there are other contributing factors ranging from if an index in the database can assist, latency of connection. Also, if only one row is expected a DataTable is overkill, consider create a class with properties to what should be returned and use that instead.
Awaiting can slow things down to and should only be used in your case if the data operations are more than say two seconds which is an eternity reading data. You could create a cancellationToken, set a time out and pass the token to your connection so if there is a problem connecting this will shorten the time to fail on a connection.