All geek questions in one place

Comparison of performance of a stored procedure written in Pl / SQL vs. Java

After discussing the discussion here , I have one more question.

Suppose there is an enterprise application with a million user base and millions of transactions every day. Efficiency to be better.

PS: When I say enterprise application development, I meant this from the point of view of developers, where we have different levels of abstraction. Testing Structures. Automated testing is deployed on multiple blade servers and advanced debugging, etc.

+3
source share
2 answers

I suspect that performance problems will go down to what kind of database operations you do. However, a very important problem for me when working with databases is testability. Many times I have been in projects that are too oriented around the database, where we end up with a bunch of business logic that I cannot unit test, test, or possibly even modify.

I am always for the sake of a pragmatic choice - everything in it is in the right place. And for some things you really have to store them in a database. But this is a question worth considering.

+4
source

, , ( , , , SQL).

, , .

+1

Source: https://habr.com/ru/post/1777510/

More articles:


All Articles