PL/SQL Stored procedures vs C# code.
675527Dec 14 2008 — edited Dec 14 2008Hi All
We are going to start designing a kind of transactional application with huge volume of data (150 million records per month). Our selected DB engine is Oracle 10.g while C# is selected development language.
Because of big volume of data performance is one of the most important factors for us, and the technical design should gain the best level of performance.
What i'm looking for and studing for it is to define which kind of operation shall be done by Stored Procedure which will be written by PL/SQL or by C# classes?
I don't interested in to handle complicated and complex jobs using PL/SQL stored procedures while the performance really deserve it.