Become a fan of Slashdot on Facebook

 



Forgot your password?
typodupeerror
×

Comment OT Re:Paradoxes Be Damned (Score 1) 334

"That's a great ID10T story. Right up there with INSERT INTO MyHugeTable (ID, Value) Values (SELECT MAX(ID)+1 From MyHugeTable, "Value") which I found on a table with one million rows when client asked why his website was so slow. "

I see almost exactly this in a newly mis-behaving app that I have to deal with. The table in question has grown very large. It bothered me when I saw it the logic. I don't have great SQL chops, but this kind of logic only works well with a serial column, right, as the DBMS will track the highest assigned value? If not, then the thing has to do index or table scans to find the value in each invocation.

CMIIW

thx, sr

Comment Re:Not a good week... (Score 1) 445

"You know, when the complexity of a problem is growing exponential, even if you could use all the energy in the universe you will not able to solve it. That is the point."

I believe that I read that before the end of classical physics, things were getting very complicated. It took various theories--electo-magnetism, relativity, quantum mechanics, etc--to make sense of the experiments that were being done at the end of that era.

Similarly, we're now trying to resolve relativity vs. quantum mechanics. I believe that the complexity that we have now is due to the fact that we have to reconcile two theories that don't match "reality", and today's experiments have complex results, and when the answer to life, the universe and everything is found, and a new unified theory supersedes modern physics, a lot of the theoretical complexity will go away.

I expect it to be less than two centuries for that to happen.

Slashdot Top Deals

I tell them to turn to the study of mathematics, for it is only there that they might escape the lusts of the flesh. -- Thomas Mann, "The Magic Mountain"

Working...