|
We have a weekly report that takes 15 minutes... been running it for a while now... then the other day, suddenly, without any changes to the query, it starts consistently taking 2 seconds.
Sometimes magic just happens!
Although we did also get rid of Kaspersky recently, coincidence?
|
|
|
|
|
We have no control over infrastructure, and anything they do on the servers or to the netowrk is some big secret. Even if they did do something, they wouldn't tell us. Beyond that, if we tell them our processes are suddenly taking a lot less time, they may take steps to "fix" it, and we'll be right back up into the hours-long stuff we were seeing last week.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
modified 3-Jan-19 10:13am.
|
|
|
|
|
John Simmons / outlaw programmer wrote: if we tell them our processes are suddenly taking a lot less time, they make take steps to "fix" it,
You do realize this is a public forum, right? 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
John Simmons / outlaw programmer wrote: if we tell them our processes are suddenly taking a lot less time, they make take steps to "fix" it,
well more likely they won't believe you are doing it correctly: in their minds if it takes half the time then you are doing something wrong and only looking at half the data
- so not so much "fix it" - but jump through hoops to prove you are not skipping some data/steps or outright cheating. Even when presented with the facts they will still look at you with some degree of distrust (i.e. that you are making it up and even your proof is somewhat fabricated to cover the truth.)
Do be careful,
Saving 10% is OK, 20% yeah, 30% - possible, but just like insurance companies anything over 30% sets off the alarms. 3 hours down to 20 min, 89%, no ones going to believe that ... or trust the system anymore
- any mistakes [related or not] that come up in the future they going to blame your fix ... "damn hacker knew letting him play around with out sensitive system and datas would cause problems - now the whole thing cant be trusted, wonder what else he broke, wonder how much data he lost, we probably need to call in some proper experts to take a look at the whole thing again.
Message Signature
(Click to edit ->)
|
|
|
|
|
Well, we're all really surprised at the outcome, and I ain't sayin' anything to anyone other than the team. We don't want the network nazis coming in and sniffing around.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
musefan wrote: get rid of Kaspersky
 Never trust the Russians for security software. 
At my old job we used Kaspersky and I had to kill it all the time because it caused my machine to be incredibly slow.
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
Quote: the last two days
You mean, since the New Year started? Coincidence? I think not! 
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
Hmm, I might be tempted to check those 300K records you are no longer accessing to see if there is any null data/duplicates or any other strange data that could be causing SQL to chug along.
|
|
|
|
|
Wonder if indices were refreshed. That has helped a bunch of our queries.
|
|
|
|
|
I could ask the dba.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
John Simmons / outlaw programmer wrote: Reduced a 7.5 hour data pull/import SQL job from 7.5 hours to 20 minutes.
Well, if your sentences are anything to go by, there still may be room for even more efficiency improvements! 
|
|
|
|
|
A million years ago when I was an IT guy and DB admin we used a 4GL DB called Progress for our MRP system. I had a custom accounts payable report that ran daily (sometimes 2x a day) that took nearly an hour. I went to the annual user's conference and attended a session held by a Progress guru. I learned a crazy 4GL Progress trick that got the report to run in...
...wait for it...
12 seconds. 
|
|
|
|
|
|
|
You know it can't be real. It must all be fake, because there are no aliens.
When you are dead, you won't even know that you are dead. It's a pain only felt by others.
Same thing when you are stupid.
modified 19-Nov-21 21:01pm.
|
|
|
|
|
Dang it! You beat me to it!
Moon landing conspiracy theories - Wikipedia[^]
New entry needed. 
Charlie Gilley
<italic>Stuck in a dysfunctional matrix from which I must escape...
"Where liberty dwells, there is my country." B. Franklin, 1783
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
|
|
|
|
|
When you are dead, you won't even know that you are dead. It's a pain only felt by others.
Same thing when you are stupid.
modified 19-Nov-21 21:01pm.
|
|
|
|
|
Marc, you do have a true talent for understatement...a "little closer"...still chuckling over that one
|
|
|
|
|
After they delivered the take-out, of course.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Chang'e probe: First pictures from moon’s ‘dark side’[^]
This should have been given more attention by news organisations -- science is far more important than politics, because it never changes, and it really does rule our lives.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Hah, you beat me to the post, as I was reading the CNET article for a relevant quote before clicking post!
Latest Article - A Concise Overview of Threads
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
That's alright Marc. Your post was at the top, so I read yours first. 
When you are dead, you won't even know that you are dead. It's a pain only felt by others.
Same thing when you are stupid.
modified 19-Nov-21 21:01pm.
|
|
|
|
|
Marc's posting must be more accurate, too, because it's more up-to-date.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I guess that probe's really just ticking away the moments that make up a dull day
|
|
|
|
|
Mark_Wallace wrote: science ... because it never changes,
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Jig | [Dance]](https://www.codeproject.com/script/Forums/Images/jig.gif)
