^. .^ Paul Wilde
@paul@notnull.space
Husband Dog owner Cat owner (multiple) FOSS Enthusiast IT Professional Coffee, no milk, no sugar I use #Alpine, by the way... (I did use #Arch, but I changed. I just still wanted the "by the way" bit I make no apologies for using H2G2 puns. We apologise for the inconvenience. #StopGenAI
notnull.space
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