Must....not....kill....
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
Listen to this and you will feel better: Adamski & Seal - Killer (Original Video Clip) - YouTube[^]
-
Listen to this and you will feel better: Adamski & Seal - Killer (Original Video Clip) - YouTube[^]
-
Listen to this and you will feel better: Adamski & Seal - Killer (Original Video Clip) - YouTube[^]
Adamski actually met that guy he was cool
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
Subject: Must....not....kill....
you can always claim self-defense.
-
Listen to this and you will feel better: Adamski & Seal - Killer (Original Video Clip) - YouTube[^]
RickZeeland wrote:
Listen to this and you will feel better: Adamski & Seal -
Restricted at work. :laugh: It'll have to wait until I get home.
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
-
Subject: Must....not....kill....
you can always claim self-defense.
Slacker007 wrote:
you can always claim self-defense.
No, this would be obvious murder. Mercy killing, granted, but still killing. :rolleyes:
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
-
Adamski actually met that guy he was cool
Haven't heard much of him after his hit with "Killer", I wonder what has become of him ...
-
I think what he needs is something more like this: Rage Against The Machine - Killing In the Name - YouTube[^]
Relaxing, that's just what Marc needs :-\
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
Marc/others - be gentle with me ;). This is what, C#? So someone seriously got carried away with cut and paste... Did I understand your rant correctly?
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
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
No no no! Do not change that, you'll break it! Don't you see that the other fields in that row of the table might change between queries? There's no transaction around these queries after all! And also the id parameter might change between queries, if a different process has write access to it. Oh, another thing: are you sure that the id column of the table is unique? So many things could go wrong with your refactoring. Better don't do that! You cannot find out what the original developer thought when he wrote that code thanks to a lack of proper documentation. :-D
Oh sanctissimi Wilhelmus, Theodorus, et Fredericus!
-
Slacker007 wrote:
you can always claim self-defense.
No, this would be obvious murder. Mercy killing, granted, but still killing. :rolleyes:
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
I prefer to think of it as giving natural selection a helping hand.
Software Zen:
delete this; -
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
I've come across worse. We had a programmer once that did a
select * from table
and then looped through the results until he found what he was looking for. Funnily enough, performance was OK on his test database, not so good on a production customer database.
-
a = cx.ExecuteQuery("select top (1) a from foo where id={0}", id).First();
b = cx.ExecuteQuery("select top (1) b from foo where id={0}", id).First();
c = cx.ExecuteQuery("select top (1) c from foo where id={0}", id).First();... and about 20 more of those, yes, each effectively querying a scalar from foo with the same qualifier. Major redaction in the above, but you get the idea. So many things wrong about this. And people here wonder why the performance of nightly jobs is so bad. :((
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
I think this is the guy you're looking for.
-
Marc/others - be gentle with me ;). This is what, C#? So someone seriously got carried away with cut and paste... Did I understand your rant correctly?
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
charlieg wrote:
with cut and paste.
Cut & paste would have been OK. This was copy and paste!
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
-
No no no! Do not change that, you'll break it! Don't you see that the other fields in that row of the table might change between queries? There's no transaction around these queries after all! And also the id parameter might change between queries, if a different process has write access to it. Oh, another thing: are you sure that the id column of the table is unique? So many things could go wrong with your refactoring. Better don't do that! You cannot find out what the original developer thought when he wrote that code thanks to a lack of proper documentation. :-D
Oh sanctissimi Wilhelmus, Theodorus, et Fredericus!
Bernhard Hiller wrote:
You cannot find out what the original developer thought
You're making a big assumption there! ;)
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
-
I think this is the guy you're looking for.
Tomaž Štih wrote:
I think this is the guy you're looking for.
Tools don't create bad code, it's the person wielding the tool!
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