PL/SQL stored procedures are indeed compiled, they are compiled to byte-code. You are mixing up things here, there's a PL/SQL engine and a SQL engine within the DB.
The PL/SQL engine just executes the stored byte-code. The SQL engine parses & executes SQL statements. Two different things. The Shared pool (to be more specific the Library cache)stores both SQL & PLSQL code.
And from 9i, you can even compile a SP to Native code.
I like stored procedures especially for one reason- They are targeted towards munging data within a relational database, and they do it damn well.
Take for example PL/SQL. Now there are damn lot of quirks in the language, but its base is rock solid. The in-built exception handling, oracle specific features just rock. The Data is stored relationally, and the best language to leverage it is the DB's own language.
Each DBMS has its strengths and weaknesses. For eg, a T-SQL developer would keep creating tons of Temporary tables to accomplish a task, which Sybase or SQLserver can execute effortlessly. The same cant be said of Oracle, in which DDLs are expensive, and a different technique has to be used. If the whole thing is written a middle-tier language, the performance most often sucks.
Having said that, I would really love a Open standards - Business rules language specification, with just one goal- to manipulate data in a relational database. A translation engine can convert this spec to optimized PL/SQL/T-SQL/$SP language. This should keep both the DBAs and the Portability gurus happy.
A spammer by definition is somebody who sends unsolicited stuff. There're still Editors at slashdot right? arent they supposed to choose stories ? If this guy knows what stories interest the slashdot audience, and present them convincingly, what's wrong with posting it?
I havent read their definition of Peak workload, but I guess it probably means concurrent queries. Even with a persistent connection, shouldnt there be a large number of concurrent queries? With things like parallel querying etc, does the number of connections have to be the same as queries?
Another factor could be caching; if intelligently used could cut down on the DB workload substantially.
M2 rocks! Opera has come a long way in v7. ~3MB download for a web/mail client is not bad in this age of bloatware. The cool part is , the mail is just a tab away.
Or he could just go with SMS, as the AC said. Or if that's too expensive, mess around with MS's free resource kit. Or even walk around the lab, talking to people(gasp).
There're plenty of free software proxy servers, firewalls on windows, no need to futz around with linux.
This doesn't really work anymore AFAIK. Windows XP made Netmeeting obsolete, MSN msgr is the default nowadays. Nobody provides ILS services anymore, except probably the server in the FAQ..
I thought IEEE spectrum mentioned Dr.Belcher was close to building it. It didnt say there was actually a device built. The Newscientist article says they have actually realized this goal.
I presume the article you are referring to is this
Slashdot Mirror
Nope. This post shows the subject in a new color!
The Parent comment alone shows how much undervalued the contributions of so many brilliant free software volunteers.
Is this what Software freedom is all about? $0 ?
Drawing block diagrams on a whiteboard with lots of illegible acronyms and connectors.
PL/SQL stored procedures are indeed compiled, they are compiled to byte-code. You are mixing up things here, there's a PL/SQL engine and a SQL engine within the DB.
The PL/SQL engine just executes the stored byte-code. The SQL engine parses & executes SQL statements. Two different things. The Shared pool (to be more specific the Library cache)stores both SQL & PLSQL code.
And from 9i, you can even compile a SP to Native code.
Cheers
I like stored procedures especially for one reason- They are targeted towards munging data within a relational database, and they do it damn well.
Take for example PL/SQL. Now there are damn lot of quirks in the language, but its base is rock solid. The in-built exception handling, oracle specific features just rock. The Data is stored relationally, and the best language to leverage it is the DB's own language.
Each DBMS has its strengths and weaknesses. For eg, a T-SQL developer would keep creating tons of Temporary tables to accomplish a task, which Sybase or SQLserver can execute effortlessly. The same cant be said of Oracle, in which DDLs are expensive, and a different technique has to be used. If the whole thing is written a middle-tier language, the performance most often sucks.
Having said that, I would really love a Open standards - Business rules language specification, with just one goal- to manipulate data in a relational database. A translation engine can convert this spec to optimized PL/SQL/T-SQL/$SP language. This should keep both the DBAs and the Portability gurus happy.
Maybe its just me, but the article seemed just like a filler, with little new info.
ZOT!
Can I return?
WTF?
A spammer by definition is somebody who sends unsolicited stuff. There're still Editors at slashdot right? arent they supposed to choose stories ? If this guy knows what stories interest the slashdot audience, and present them convincingly, what's wrong with posting it?
Wonder why nobody said such a thing when VA tech built a cluster with Mac OS X ? Just because it has a BSD subsystem ?;)
Perhaps he is corect.. The free() function just deallocates memory, delete does a whole lot more AFAIK, calling destructors and the like.
While I agree that C++ can be as dangerous as Assembler, use of proper libraries/STL does improve the situation.
Wowzers. Reinventing APL are we ;)
Damn straight. They should have named it GNU/Glibc/XFree(C)TM/QT/KDE/Ruby-Lang/Rubyx .
I havent read their definition of Peak workload, but I guess it probably means concurrent queries. Even with a persistent connection, shouldnt there be a large number of concurrent queries? With things like parallel querying etc, does the number of connections have to be the same as queries?
Another factor could be caching; if intelligently used could cut down on the DB workload substantially.
It's also worth checking out rijk's page, especially Hugin and Munin.
I cant believe they dont have a web browser and email client in it yet.
There're plenty of free software proxy servers, firewalls on windows, no need to futz around with linux.
Somebody released an xpdf version which claims to read secure PDF documents, and honours the permissions(meaning no copy/paste,printing etc).
Same here, but we have monkeys.
We have 17 monkeys for each programmer, a total of around 142 monkeys and 5 programmers.
We made 1.7 billion Iraqi dinars last year.
This doesn't really work anymore AFAIK. Windows XP made Netmeeting obsolete, MSN msgr is the default nowadays. Nobody provides ILS services anymore, except probably the server in the FAQ..
I thought IEEE spectrum mentioned Dr.Belcher was close to building it. It didnt say there was actually a device built. The Newscientist article says they have actually realized this goal.
I presume the article you are referring to is this
Your point is well-taken. I have seen a number of +5 info. posts which are out-right wrong. Moderators do take action when pointed out.
I'd just like to think unless the OP was deliberately trying to mis-inform, there is no reason for abuse.
Thanks for responding:)
Why are learned people incredibly prone to verbally abuse somebody who is wrong?
and empowered ;)
You know, this must be like shooting fish in a barrel for you now ;) Move over Klerck. It's not worth it anymore..