Analysis of the efficiency of Apex and Java languages and related technologies in performing database operations

The article presents the results of research on the impact of programming language and database system on application performance. The aim was to indicate which technologies perform better under different workloads. Java with PostgreSQL/MySQL was compared to the cloud-based Salesforce solution using Apex. Java handles sequential operations more efficiently, while Apex provides greater stability and scalability. The optimal choice depends on the application’s characteristics and environment.