The DB was locking up when trying to retrieve data from a large table (>10 M rows) using a very complex query.The oracle guys kept suggesting that reduce the size of the table.
Now seriously is that a valid option ? Hey man , I have a million bucks in my acct. and i can't withdraw from the ATM ?? Just delete some of it and then try again ?
Oh. My. God.
You know, normally people would simply add or subtract from a number, and log a transaction for the amount when changing this- not insert a row for each dollar. If you add $10 to your account, you would do something like
INSERT INTO Transactions (ACCT_NUM, AMOUNT, TRAN_DATE) VALUES (, 10.0, SYSDATE)
UPDATE TotalFunds SET TOTAL_AMOUNT = TOTAL_AMOUNT + 10.0 WHERE ACCT_NUM =
(of course do both items within a transaction).
If you are making 10 entries of 1 and I worked at oracle, I would tell you to shrink your table too! Then I would make fun of you after the call..
I'm glad to see those in the Open Source community finally accepting the superiority of not reinventing the wheel...
That's the whole idea behind open software- not having to re-invent the wheel.
With open source, you can just grab code from something else to add your functionality.
As far as this helping Microsoft, the Xbox itself is a lost-leader for their games. They lose money on every sale but hope to make it back via game purchases.
you have to agree not to operate the vehicle if you purchase it.
So how would you know it worked?
I guess you could look at it like being married.
Re:Isn't deleting logs an obstruction of justice?
on
Cryptome Log Subpoenaed
·
· Score: 5, Insightful
You havn't ever actually maintained a web site, have you?
Logs typically get compressed nightly, and deleted frequently.
I've maintained sites that literally filled GBs of disk with log data. And it gets much more expensive (CPU cost) to process huge files. Typically, you end up picking some time frame which you compress the files at, and maintain a regular deletion cycle.
Of course you would also create reports for management and marketing, but those reports contain very few specific details like IPs, and lots of details about counts per page/directory/product item.
You really can't maintain an interesting site without frequent log deletion. I'm surprised they took the "protect the privacy of our users" route- it would be a Bad Thing [TM] to have someone get a court ruling made that websites must save all logs for a period of 5 years or something equally insane.
Anyone worth their salt who is doing anything bad is using a proxy anyway.
They're going to come up with a draconian, unworkable model that everyone hates. Then they back off to something that we (that being the technically savvy users) still find offensive but that the normal schmoe thinks is a good deal.
So you are saying it's sort of like back when I was in college and would call home to beg for $100, then back off to "I could probably stretch my resources and get by with $50". It usually worked.
At the University of Arizona, we purchased a site license for their product line at an enourmous price
Actually, the price wasn't that enourmous. And it was actually a really good deal. Heck- just ask Face about the RDBMS deal sometime. He typically can't stop giggling.
What makes it look enourmous is it was a blanket package for *everything*, and we probably really only needed the base product (oracle 8i/9i) and portal/9iAS.
But now any student/staff/faculty member can have and keep the software for the cost of media, or just download it.
I've been wondering when Microsoft will write their own closed mail protocol that effectively gets rid of spam
LOL- I ended up having to sign up for a hotmail account to do IM at work with a small group of developers/systems people during integration testing. I gave that hotmail address to no one. But I still get around 15 spam messages there every day.
I really don't think MS cares about the spam problem. And after all the outlook bugs I've seen, I don't think they have much credibility where email apps/services are concerned.
How enlightened you are. You must also ask your mother her technique for grinding flour and raising chickens when she bakes your birthday cake "from scratch."
To make apple pie from scratch, you must first create the universe.
-Carl Sagan
A Gigabit solution is just now getting to the point of being affordable.
Well, it's not like you can't have that too. Over at newegg, you can pick up a ASUS A7V8X for $144.00. Gigabit networking onboard, USB 2.0, IEEE1394, supports up to DDR400.
Then click back to the home page and note that you can pick up a boxed AMD 2000XP for $91. Just add need memory, video card, a case, and drives. Memory: $137.00 for Samsung 512MB CAS 2.5. You can certainly get faster, but that's about where the price break is, and it kicks the pc133's butt. Video card $219 for the same one as in the ad (I mean article). The case is around $50 for a good screwless model, CD-RW less than $50 (I just picked on up for $20 after rebates- you might notice they didn't include a CD-RW in the article), and for a hard drive, grab the same one in the article for $100. Maybe grab some extra case fans for $4-6 each?
So that's a *good* machine, brand new, for about $795 +shipping (which isn't going to be much) with all the extras. Gigabit networking, USB 2.0, Firewire, pretty much everything.
But you can build the used g4 for $1730 if you prefer.
I'd love to get a mac, but whenever I compare where I can get the most flexibility and bang for the buck, I end up with another PC. My next laptop, however, will be a powerbook.
5 days maditory vacation, and both Christmas and New Years Day as a holiday. I'm fortunate in that all the overtime I've put in can be converted to comp time, and I can use that instead. Not everyone is as lucky (to be allowed to get/use comp time).
So, I get some time to get things done around the house, go see LotR II, and generally relax and de-stress.
That is as long as nothing at work breaks (because then I'd have to go into work).
And no, I'm not complaining, I'm looking forward to it- I can use the break. But I sure hope nothing breaks.
I never understood why computer geeks working in cold labs suck down the caffenine.
Because when we find ourselves in the data center at the system console, it's usually because something Very Bad has happened. Our brain decides (at a subliminal level) to take drastic measures to avoid having to deal with such tasks in the future.
They will either squash Sony's box through legislation or deals with the cable companies, or, they will lower their prices.
Competition == Good for consumers ALWAYS.
So how do you suppose they will lower their prices?
What do you suppose the top brass are going to gather together in a board room and determine to be the best way to cut prices? Layoffs. Transfer more of the scut work to some 3rd world plants.
And of course give themselves a fat bonus for such creative thinking.
Layoffs really don't help the economy. They should by no means be interpreted as something "good" for consumers.
Slashdot Mirror
Oh. My. God.
You know, normally people would simply add or subtract from a number, and log a transaction for the amount when changing this- not insert a row for each dollar. If you add $10 to your account, you would do something like
INSERT INTO Transactions (ACCT_NUM, AMOUNT, TRAN_DATE) VALUES (, 10.0, SYSDATE)
UPDATE TotalFunds SET
TOTAL_AMOUNT = TOTAL_AMOUNT + 10.0
WHERE ACCT_NUM =
(of course do both items within a transaction).
If you are making 10 entries of 1 and I worked at oracle, I would tell you to shrink your table too! Then I would make fun of you after the call..
Or as The Register pointed out, near a pacemaker.
With open source, you can just grab code from something else to add your functionality.
As far as this helping Microsoft, the Xbox itself is a lost-leader for their games. They lose money on every sale but hope to make it back via game purchases.
Go do your research. There is quite a bit of information on quieting your PC out there, and quite a bit of specialized hardware out there to do this.
Go to google and search for "quiet PC" or click here.
There are plenty of cases/fans/and everything else out there to silence a PC. You just have to look.
Where have you been? Your response should have been more like:
Huzzah! A slashdot story posted with *no* spelling errors, with comprehensible sentence structure!
Go CowboyNeal!
So how would you know it worked?
I guess you could look at it like being married.
You havn't ever actually maintained a web site, have you?
Logs typically get compressed nightly, and deleted frequently.
I've maintained sites that literally filled GBs of disk with log data. And it gets much more expensive (CPU cost) to process huge files. Typically, you end up picking some time frame which you compress the files at, and maintain a regular deletion cycle.
Of course you would also create reports for management and marketing, but those reports contain very few specific details like IPs, and lots of details about counts per page/directory/product item.
You really can't maintain an interesting site without frequent log deletion. I'm surprised they took the "protect the privacy of our users" route- it would be a Bad Thing [TM] to have someone get a court ruling made that websites must save all logs for a period of 5 years or something equally insane.
Anyone worth their salt who is doing anything bad is using a proxy anyway.
So you are saying it's sort of like back when I was in college and would call home to beg for $100, then back off to "I could probably stretch my resources and get by with $50". It usually worked.
Of course I really only wanted $20 for pizza.
Actually, the price wasn't that enourmous. And it was actually a really good deal. Heck- just ask Face about the RDBMS deal sometime. He typically can't stop giggling.
What makes it look enourmous is it was a blanket package for *everything*, and we probably really only needed the base product (oracle 8i/9i) and portal/9iAS.
But now any student/staff/faculty member can have and keep the software for the cost of media, or just download it.
LOL- I ended up having to sign up for a hotmail account to do IM at work with a small group of developers/systems people during integration testing. I gave that hotmail address to no one. But I still get around 15 spam messages there every day.
I really don't think MS cares about the spam problem. And after all the outlook bugs I've seen, I don't think they have much credibility where email apps/services are concerned.
To make apple pie from scratch, you must first create the universe.
-Carl Sagan
Well, it's not like you can't have that too. Over at newegg, you can pick up a ASUS A7V8X for $144.00. Gigabit networking onboard, USB 2.0, IEEE1394, supports up to DDR400.
Then click back to the home page and note that you can pick up a boxed AMD 2000XP for $91. Just add need memory, video card, a case, and drives.
Memory: $137.00 for Samsung 512MB CAS 2.5. You can certainly get faster, but that's about where the price break is, and it kicks the pc133's butt. Video card $219 for the same one as in the ad (I mean article). The case is around $50 for a good screwless model, CD-RW less than $50 (I just picked on up for $20 after rebates- you might notice they didn't include a CD-RW in the article), and for a hard drive, grab the same one in the article for $100. Maybe grab some extra case fans for $4-6 each?
So that's a *good* machine, brand new, for about $795 +shipping (which isn't going to be much) with all the extras. Gigabit networking, USB 2.0, Firewire, pretty much everything.
But you can build the used g4 for $1730 if you prefer.
I'd love to get a mac, but whenever I compare where I can get the most flexibility and bang for the buck, I end up with another PC. My next laptop, however, will be a powerbook.
5 days maditory vacation, and both Christmas and New Years Day as a holiday. I'm fortunate in that all the overtime I've put in can be converted to comp time, and I can use that instead. Not everyone is as lucky (to be allowed to get/use comp time).
So, I get some time to get things done around the house, go see LotR II, and generally relax and de-stress.
That is as long as nothing at work breaks (because then I'd have to go into work).
And no, I'm not complaining, I'm looking forward to it- I can use the break. But I sure hope nothing breaks.
Who knows, maybe I'll get a bobble head doll too.
Negatives:
- You probably populated the array with the same drives from the same manufacturer, all from the same batch.
And they will probably all fail at about the same time.
You could start by subscribing to the forensics mailing list over at securityfocus.com. The honeypots list is also of interest.
Both lists have a fairly good signal-to-noise ratio, and there is a lot of good info to be had.
If nothing else, it's certainly a good place to ask that exact question.
You can sign up here.
Because when we find ourselves in the data center at the system console, it's usually because something Very Bad has happened. Our brain decides (at a subliminal level) to take drastic measures to avoid having to deal with such tasks in the future.
So how do you suppose they will lower their prices?
What do you suppose the top brass are going to gather together in a board room and determine to be the best way to cut prices? Layoffs. Transfer more of the scut work to some 3rd world plants.
And of course give themselves a fat bonus for such creative thinking.
Layoffs really don't help the economy. They should by no means be interpreted as something "good" for consumers.
Judging by the Yoda-speak, you must have opted to get Star Wars II instead of the LotR collectors edition, eh?
Those concrete pipes come in sizes up to 144 inches. That would be 12 foot.
I think you'd fit.
The problem I have with the idea is basically you would be designing your home in the likeness of a sewer..
I believe they need to define the word "refresh".
Perhaps they invested in IBM Deathstars, and find themselves "refreshing" large portions from backup on a daily basis?
Parent is underrated.
On *this* article the half-screen ad that shows up is for visual studio.net?
Oh my..
Yes, but at home it's quick. Abroad much more likely to be long, drawn out, and painful.
But then it depends upon the abroad..
Have you looked here?
I remember building a 0.95c system. There are older versions there, like before there was math coprocessor support or virtual terminals.
Plenty of release notes there too.
It's more like not wearing a seatbelt while playing GTA3.
It's not like you actually *die* if you lose your files. It just sucks because you have to start over.