Will PL/SQL become worthless in the future?
548150Dec 10 2009 — edited Dec 14 2009Will PL/SQL become worthless in the future?
In my opinion, the answer is yes.
We are undertaking a project now. We have to replace all of the PL/SQL code with the corresponding Java code. The reason is we are planning to add an in-memory Oracle Meddleware software into the existing system. In order to get better performance, we decide to keep all the database table data in memory and create in-memory Java objects to hold the conrresponding table data. Unfortunately, after implement JPA/ORM, any modification work must be done through the in-memory java objects and then persist the updated data to the conrresponding tables. So any direct-database modification (stored procedures---PL/SQL code) is not permmited.
Today, for sake of better performance, in-memory data technoologies become more and more polular. But in-memory data technology and PL/SQL are mutually exclusive.