|
this to me reminds me of the differences in Apple vs Microsoft.
Apple makes hardware(great hardware) and have software that runs on it. Microsoft makes software and sometimes makes hardware for it.
To err is human to really elephant it up you need a computer
|
|
|
|
|
Due to one thing and another, I've upgraded from SQL Server Express 2012 for my dev system to SQL Server Developer Edition 2019 (I like to keep the DB engine at the same version as the production server - it means I don't use features that aren't available, and the hosting service was running 2012 until recently).
And once I'd unpicked what the Data Migration Assistant wanted me to do (why is it that complicated, given you'll probably use it once or twice a decade?) my dev DB's moved over nicely.
Fortunately, I did this a while ago: Instance Storage - A Simple Way to Share Configuration Data among Applications[^] so changing to the new Server instance was a single location change and all my apps switch over.
So I test them ... and blow me but it's quick! The apps load maybe ten times faster? Almost immediately, instead of a couple of seconds delay while they sort out the initial data. Impressive stuff!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I think I need to add a head-slap reaction 
SQL has indeed come a long way in 10 years. I'm trying hard to ween myself off it but it's too powerful a drug.
cheers
Chris Maunder
|
|
|
|
|
Chris Maunder wrote: I'm trying hard to ween myself off
Why? 
|
|
|
|
|
OriginalGriff wrote: The apps load maybe ten times faster?
Give it a few days. 
|
|
|
|
|
There are some major differences between the two that result in the bulk of the performance improvements:
1) SQL Server Express 2012 is limited to using 1 GB of RAM and is single threaded
2) SQL Server Developer 2019 is the full blown SQL Server Enterprise 2019 with a developer only license and will use all memory and performs SQL Server specific thread management.
3) SQL Server Express (all versions) doesn't attempt to optimize queries before execution; SQL Server Professional and Enterprise have a rather good query optimizer.
You would have seen similar performance enhancements moving from SQL Express 2012 to SQL Enterprise 2012. The remaining performance improvements are the result of Microsoft improving SQL Server's performance in general.
Also, Microsoft did a ground up rewrite of SQL Server 2019 to make it run on Linux as well as Windows and in the process eliminated a lot of internal performance bottlenecks.
modified 23-Jun-22 10:01am.
|
|
|
|
|
Nice to know I'm not imagining it.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: The apps load maybe ten times faster?
I've been using it (2019 Dev) for a couple of years now in prod and never noticed performance gains over previous versions.
I'll run some tests and get back to you on that.  I've been putting off installing a 2019 instance on my main dev system due to low disk space. This may be the determination of how soon I replace this non-upgradable tower and join the rest of you on 11.
"Go forth into the source" - Neal Morse
"Hope is contagious"
|
|
|
|
|
See obermd's response. I guess the earlier editions of Express were single threaded and only used 10MB of RAM whereas the new ones do not have that limitation. You were probably running commercial servers and so you were not subject to that limitation.
To err is human. Fortune favors the monsters.
|
|
|
|
|
Good catch - SQL Server Express was limited to 1 GB RAM. I've updated the post.
For SQL Server Express 2019:
16 cores (threads)
64 GB RAM max
SQL Server Express 2019 is far more powerful than 2012 was but still doesn't have the performance enhancements of SQL Server 2019 Standard or Enterprise.
|
|
|
|
|
I thought 10MB seemed small, but these days anything in the MB range seems generous to me so I didn't question it. 
To err is human. Fortune favors the monsters.
|
|
|
|
|
OriginalGriff wrote: changing to the new Server instance was a single location change and all my apps switch over
That's why I tend to use an alias[^].
(Although it technically requires two changes, since there's a separate list of aliases for x86 and x64.)
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Doesn't express have memory and cpu core limitations that dev and the commercial editions don't? That would almost certainly explain it.
Personally I like testing on low memory, low cpu SQL because it forces me to optimize performance.
|
|
|
|
|
Referring to the backless sandals with strap over the base of the toes and a post between the first 2 toes...
Here in the north central US they are called flip flops. My mom called them zorries, my grandmother called them thongs.
I'm curious as to what name you use.
|
|
|
|
|
Round these parts, "thongs" go on a totally different body area and aren't normally seen in public ... 
It's flip-flops for us. But please, not with socks.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yeah - thongs in Oz, too. Always scares the North American tourists.
cheers
Chris Maunder
|
|
|
|
|
And the Oz version of Durex doesn't do the same job either! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
...or rubbers
My first naive trip to the US office (early 70s) I learned the hard way about asking for an eraser.
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
If you're a British smoker, don't even think about asking a USian if you can "bum a fag".
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Birkenstocks (brand of flip flop) with socks is a standard fashion statement in Boulder, CO.
|
|
|
|
|
Remind me never to go there ...
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Quote: Round these parts, "thongs" go on a totally different body area and aren't normally seen in public ... Unsure |
Except maybe in Essex!
modified 6-Sep-22 21:01pm.
|
|
|
|
|
Red Neck Wing Tips
The most expensive tool is a cheap tool. Gareth Branwyn
JaxCoder.com
|
|
|
|
|
Teenslippers 
|
|
|
|
|
It's called "Hawaii chappal" over here - no specific idea why, though
Happiness will never come to those who fail to appreciate what they already have. -Anon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
