Post #3704679
2026-07-09 22:51 UTC
Yo #Database nerds!
Quick question - would approx 8 seconds be a reasonable transaction time when returning 5 million rows of a single column over a VPN connection ?
Standalone Windows Server VM (ew), spinning rust SAS drives , generally well performing all round. Loads of ram and cores, but guess what... it's SQLExpress so no matter what I give it it won't be used.
I think 8 seconds is OK.... I'm right, right?
Please note I am not asking for ways to improve this, I am asking if this would be considered acceptable given the constraints.
Basically, I need to tell some software developers to make their database calls more efficient and not blame the servers.
(If your application needs to make loads of database calls returning every result in the table so the client application can do some work, maybe investigate ways to improve this!!! (Oh, and don't use MSSQL (and definitely not SQLExpress)))
#SysAdmin #MSSQL #SQLExpress
Replies (1)
-
@sudonem@infosec.exchange 2026-07-09 23:09
@paul@notnull.space This seems incredibly respectable given the parameters you’ve defined. SQLExpress for this is… crazy though. If they realistically do need that size query result somewhat frequently, in addition to just making the calls more efficient, I’d also be asking if the back end database of choice is appropriate (SQL might not be the best choice for example, but if it IS maybe we haven’t done the work of normalization, or maybe we need a dedicated read replica etc etc).