Yeah, that's almost like Coppola making Godfather Part III without Bobby Duvall. Wait, they made Part III? And they used George Hamilton? Somebody call Eisner!!!
Compare the survival rate with your average airline accident...
The beautiful thing about the internet is that you can easily compare the Hindenberg's survival rate with the average airline accident survial rate. I found the following when I searched "airline accident survial rate' using Vivisimo.com:
Your friend's story is not all that unusual, unfortunately. I've heard of similar stories around AR_UPDATE, altough that was a few versions ago. I haven't heard of anything that bad since version 8 of the software came out.
In PeopleSoft's defense, they did not create their system to run on one particular database. Of course, that means when you tune it to run better on DB2, that means your next client (on Oracle) would end up requiring a different type of tuning.
Not surprised about the data issue with that Query. You may want check and make sure that the configuration of cost accounting is correct. With all of those views, I imagine some of the joins actually cross over the same tables a few times (I hope you understand what I mean by that sentence). Nine times out of ten, it has something to do with configuration.
What? You can't figure that one out? Come on! And, it's only a 20 way union. The GGP said a 25 or 30 way join.:)
Seriously, That is a bear. The best part is that it's a series unions built on views (I don't see any tables, only views). Obviously, the developer that created this monstrosity had to be on some painkillers. Once the original tables have some data loaded in them, the performance of that SQL will probably slow to a crawl.
I'm actually sitting in a building with some other (company unidentified, but different than my company) consultants and I had previously asked them about a 20 way union in AP or GL and they had never heard of it. One of them did mention that in some of the Supply Chain modules (and I think Cost Accounting would fall in that area) they had seem some mega-joins. Personally, I recalled a nasty series of left outer joins in the e-Procurment module (all of theleft outer joins I am thinking of were built upon each other using views).
Apparently, PeopleSoft has been going through some of the older modules (AP and GL) and they have eliminated some of the existing nasty SQLs. Now, according to rumor, PeopleSoft was trying to fix SQL problems that occur in the newer modules, like the one you show above. Of course, eliminating that monstrosity may take a few versions.
Dammit, I clicked the above link for those who are don't know what OQO is but its teh down. I guess there're a lot of people that don't know what it is.
Well, according to OQO.com:
The OQO model 01 is also the most versatile computer to date.
Does this mean it can be a server strong enough to prevent slashdotting?
We use PeopleSoft and one of our tech has been debugging an AP (maybe GL?) query that's not working as expected and it's a 20 union beast.
A 20 union beast in delivered AP or GL? I've been working PeopleSoft for nine years. I do not recall that ever occuring. The delivered printed Check in AP is a bit hairy, with 10 tables or so, but I don't think that is a union.
Seroiusly, tell me where that union is. I'm curious. Post it here.
Now go learn about these things and stop acting like know anything about "business processes.
I think you are the one that is naive. Either that or you need to reassess how you've been performing your job. I work on ERP systems (PeopleSoft). I have been working on it for 9 years. In those nine years, I've been saying "change your business process" almost once a week, and I've never been laid off. Even during the dark days right after 9/11, I was working because the client knew I was correct.
There is only one instance that I know of where I have ever had to join more than 10 tables. And, that was because the client REFUSED to listen to me and change their business processes. I spent two months working at it and still I don't think it was worth the effort.
If I have to create a large join, I talk to the client about finding a different way to get the data. Some folks may think I cheat, as in create a smaller view, along with some external programming (using a language called SQR). I would disagree that it isn't cheating. A 25-way join is very inefficient and is not worth the cost of developing. You should try to find a new way to do the business.
Admittedly, when PeopleSoft delivers their software, they do deliver some massive joins. But, that is their decision. And, I do not recall a single instance where I've seen a delivered 25-way join. As long as I am programming for their crappy software, I never will never create one.
Do you know what would really be helpful? If Slashdot had some sort of "preview" function. That way, you could preview your post before you submited it.
See, that's why they pay me the seven figure salary. I'm an thought leader.
"Before, such mutant genes were only found in Caucasians. The finding has encouraged us to do further research in China, with the aim of developing medicines to prevent and cure HIV/AIDS for different races,"said Zhu.
Sounds like some mutant genes have been found previously, so I am not sure if this will add any new information to the fight against AIDS.
China is now at a key moment in adopting effective measures to control and prevent HIV/AIDS as the disease moves from high risk populations to the general population, in most cases though sexual transmission, Zhu pointed out.
China had better be prepared for a potential disaster. Even if the presense of this "mutant" gene does lead to some sort of cure, it will probably take years to develop and test. In the meantime, China, along with most Middle Eastern and Asian countries, has a high risk of having an AIDS related disaster of a scope way beyond what we now see in Africa. We're talking tens of millions of people infected and/or dying all across the Middle East and Asia.
True. But, I'm confused. The Libertarians believe that government should stay out of everyone's lives. Are they contradicting their mission by using the court system to make their argument?
Yeah, I know, maybe I'm stretching it a bit, but hey, I'm bored today.
Slashdot Mirror
Uh, make that 'sarcasm' tags.
Must...remember...to...push...preview...button.
Next time, I promise to include the required tags.
I hear that Jar Jar is looking for work.
Yeah, that's almost like Coppola making Godfather Part III without Bobby Duvall. Wait, they made Part III? And they used George Hamilton? Somebody call Eisner!!!
"Computer?"
"Working"
"Program the holodeck to look like the inside of a seedy 1920's era Jazz Club. We need to write another time machine episode."
True, but it is STILL one helluva lot more useful than the Segway.
Sorry. I forgot to include the tags.
Try this link.
Compare the survival rate with your average airline accident...
The beautiful thing about the internet is that you can easily compare the Hindenberg's survival rate with the average airline accident survial rate. I found the following when I searched "airline accident survial rate' using Vivisimo.com:
http://airsafe.com/airline.htmAre you talkin' to ME?
Your friend's story is not all that unusual, unfortunately. I've heard of similar stories around AR_UPDATE, altough that was a few versions ago. I haven't heard of anything that bad since version 8 of the software came out.
In PeopleSoft's defense, they did not create their system to run on one particular database. Of course, that means when you tune it to run better on DB2, that means your next client (on Oracle) would end up requiring a different type of tuning.
Not surprised about the data issue with that Query. You may want check and make sure that the configuration of cost accounting is correct. With all of those views, I imagine some of the joins actually cross over the same tables a few times (I hope you understand what I mean by that sentence). Nine times out of ten, it has something to do with configuration.
What? You can't figure that one out? Come on! And, it's only a 20 way union. The GGP said a 25 or 30 way join. :)
Seriously, That is a bear. The best part is that it's a series unions built on views (I don't see any tables, only views). Obviously, the developer that created this monstrosity had to be on some painkillers. Once the original tables have some data loaded in them, the performance of that SQL will probably slow to a crawl.
I'm actually sitting in a building with some other (company unidentified, but different than my company) consultants and I had previously asked them about a 20 way union in AP or GL and they had never heard of it. One of them did mention that in some of the Supply Chain modules (and I think Cost Accounting would fall in that area) they had seem some mega-joins. Personally, I recalled a nasty series of left outer joins in the e-Procurment module (all of theleft outer joins I am thinking of were built upon each other using views).
Apparently, PeopleSoft has been going through some of the older modules (AP and GL) and they have eliminated some of the existing nasty SQLs. Now, according to rumor, PeopleSoft was trying to fix SQL problems that occur in the newer modules, like the one you show above. Of course, eliminating that monstrosity may take a few versions.
Well, according to OQO.com:
The OQO model 01 is also the most versatile computer to date.Does this mean it can be a server strong enough to prevent slashdotting?
A 20 union beast in delivered AP or GL? I've been working PeopleSoft for nine years. I do not recall that ever occuring. The delivered printed Check in AP is a bit hairy, with 10 tables or so, but I don't think that is a union.
Seroiusly, tell me where that union is. I'm curious. Post it here.
I think you are the one that is naive. Either that or you need to reassess how you've been performing your job. I work on ERP systems (PeopleSoft). I have been working on it for 9 years. In those nine years, I've been saying "change your business process" almost once a week, and I've never been laid off. Even during the dark days right after 9/11, I was working because the client knew I was correct.
There is only one instance that I know of where I have ever had to join more than 10 tables. And, that was because the client REFUSED to listen to me and change their business processes. I spent two months working at it and still I don't think it was worth the effort.
If I have to create a large join, I talk to the client about finding a different way to get the data. Some folks may think I cheat, as in create a smaller view, along with some external programming (using a language called SQR). I would disagree that it isn't cheating. A 25-way join is very inefficient and is not worth the cost of developing. You should try to find a new way to do the business.
Admittedly, when PeopleSoft delivers their software, they do deliver some massive joins. But, that is their decision. And, I do not recall a single instance where I've seen a delivered 25-way join. As long as I am programming for their crappy software, I never will never create one.
Even if I couln't see your UID, that phrase above would give you away as being "new around here".
Agreed. But, then again, the only command I EVER need is TRUNCATE. All other SQL commands are useless.
Woops! You know, I searched for Dupes before I submitted the article. I guess I just didn't go back far enough in time. Sorry.
Or, you could just buy an ATV with a trailer.
Off topic. But, you missed Talk like a Pirate Day! by a few weeks.
See, I told you they needed a "preview" function!
Do you know what would really be helpful? If Slashdot had some sort of "preview" function. That way, you could preview your post before you submited it.
See, that's why they pay me the seven figure salary. I'm an thought leader.
So, with twice as many wheels as the Segway, will it be twice as useless?
Trust me, that abrupt "stoppage" usually lasts much, much longer than nine months...
From the article
"Before, such mutant genes were only found in Caucasians. The finding has encouraged us to do further research in China, with the aim of developing medicines to prevent and cure HIV/AIDS for different races,"said Zhu.Sounds like some mutant genes have been found previously, so I am not sure if this will add any new information to the fight against AIDS.
China is now at a key moment in adopting effective measures to control and prevent HIV/AIDS as the disease moves from high risk populations to the general population, in most cases though sexual transmission, Zhu pointed out.China had better be prepared for a potential disaster. Even if the presense of this "mutant" gene does lead to some sort of cure, it will probably take years to develop and test. In the meantime, China, along with most Middle Eastern and Asian countries, has a high risk of having an AIDS related disaster of a scope way beyond what we now see in Africa. We're talking tens of millions of people infected and/or dying all across the Middle East and Asia.
True. But, I'm confused. The Libertarians believe that government should stay out of everyone's lives. Are they contradicting their mission by using the court system to make their argument?
Yeah, I know, maybe I'm stretching it a bit, but hey, I'm bored today.