Analysis of the efficiency of Apex and Java languages and related technologies in performing database operations
Article Sidebar
Open full text
Issue Vol. 37 (2025)
-
Performance evaluation of Machine Learning and Deep Learning models for 5G resource allocation
Abdullah Havolli, Majlinda Fetaji371-378
-
Analysis of the use of object detection systems in edge computing
Jakub Kozłowski, Marcin Badurowicz379-390
-
Performance analysis of Jetpack Compose components in mobile applications
Adrian Kwiatkowski, Jakub Smołka391-398
-
Methods for comparing three-dimensional motion trajectories
Tomasz Waldemar Samorow, Maria Skublewska-Paszkowska399-404
-
Performance and scalability analysis of monolithic and microservice architectures in social networks
Viacheslav Chernohor405-409
-
Comparative analysis of methods for identifying tree structures of coronary vessels
Kacper Liżewski, Małgorzata Charytanowicz410-417
-
Websites accessibility assessment of voivodeship cities in Poland
Kacper Czajka, Maria Skublewska-Paszkowska418-425
-
Analysis of ORM framework approaches for Node.js
Serhii Zhadko-Bazilevych426-430
-
Analysis of performance optimization methods for 3D games in the Unity environment
Maciej Potręć, Marcin Badurowicz431-435
-
The impact of AI use on the performance of chess engines
Jakub Król, Jakub Smołka436-442
-
Evaluating the effectiveness of selected tools in recognizing emotions from facial photos
Klaudiusz Wierzbowski443-450
-
Performance analysis of the GraphQL API creation technologies using Spring Boot and NestJS
Jakub Maciej Tkaczyk, Beata Pańczyk451-456
-
Comparative Performance Analysis of RabbitMQ and Kafka Message Queue Systems in Spring Boot and ASP.NET Environments
Filip Kamiński, Radosław Kłonica, Beata Pańczyk457-462
-
Analysis of current threats and security measures used in web applications on the example of Symfony, Express, and Spring Boot
Karol Kurowski, Magdalena Kramek463-469
-
The use of machine learning to classify symbols on cultural monuments to identify their origin and historical period.
Igor Pajura, Sylwester Korga470-475
-
Investigating Machine Learning Algorithms for Stroke Occurrence Prediction
Kazeem B. Adedeji, Titilayo A. Ogunjobi, Thabane H. Shabangu, Joshua A. Omowaye476-483
-
Comparative performance analysis of Spring Boot and Quarkus frameworks in Java applications
Grzegorz Szymanek, Jakub Smołka484-491
-
Influence of activation function in deep learning for cutaneous melanoma identification
Adrian Szymczyk, Maria Skublewska-Paszkowska492-499
-
Analysis of methods for simulating character encounters in a game with RPG elements
Michał Zdybel, Jakub Smołka500-507
-
Analysis of the efficiency of Apex and Java languages and related technologies in performing database operations
Marcin Janczarek, Konrad Lewicki, Jakub Smołka508-514
Main Article Content
DOI
Authors
Abstract
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.
Keywords:
References
[1] Stack Overflow, Developer Survey 2025 – Technology (Java), https://survey.stackoverflow.co/2025/technology, [10.09.2025].
[2] What is Apex? Salesforce Developer Guide, https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_intro_what_is_apex.htm, [10.09.2025].
[3] Best Practices for Deployments with Large Data Volumes, https://developer.salesforce.com/docs/atlas.en-us.256.0.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_introduction.htm, [10.09.2025].
[4] D. R. Miącz, Performance analysis of methods for building applications on the Salesforce platform, Journal of Computer Sciences Institute 10 (2019) 24–27, https://doi.org/10.35784/jcsi.189.
[5] W. Marańda, A. Poniszewska-Marańda, M. Szymczyńska, Data Processing in Cloud Computing Model on the Example of Salesforce Cloud, Information 13(2) (2020) 85, https://doi.org/10.3390/info13020085.
[6] A. Poniszewska-Maranda, R. Matusiak, N. Kryvinska, Ansar-Ul-Haque Yasar, A real-time service system in the cloud, Journal of Ambient Intelligence and Humanized Computing 11 (2020) 961–977, https://doi.org/10.1007/s12652-019-01203-7.
[7] A. M. Bonteanu, C. Tudose, Performance Analysis and Improvement for CRUD Operations in Relational Databases from Java Programs Using JPA, Hibernate, Spring Data JPA, Applied Sciences 14(7) (2024) 2743, https://doi.org/10.3390/app14072743.
[8] T. Taipalus, Database management system performance comparisons: A systematic literature review, Journal of Systems and Software 208(2) (2023) 111872, https://doi.org/10.1016/j.jss.2023.111872.
[9] N. Zingirian, M. Maresca, S. Nalin, Efficiency of standard software architectures for Java-based access to remote databases, Future Generation Computer Systems 15(3) (1999) 417-424, https://doi.org/10.1016/S0167-739X(98)00085-5.
[10] A. Ginanjar, M. Hendayun, Spring Framework Reliability Investigation Against Database Bridging Layer Using Java Platform, Procedia Computer Science 161 (2019) 1036-1045, https://doi.org/10.1016/j.procs.2019.11.214.
[11] S. Zań, Evaluating Database and Indexing Performance on the Salesforce Platform, Master thesis, Polish-Japanese Academy of Information Technology, Warsaw, 2025.
Article Details
Abstract views: 18
Marcin Janczarek, Department of Computer Science, Lublin University of Technology, Nadbystrzycka 36B, 20-618 Lublin
Department of Computer Science
Konrad Lewicki, Department of Computer Science, Lublin University of Technology, Nadbystrzycka 36B, 20-618 Lublin
Department of Computer Science
Jakub Smołka, Department of Computer Science, Lublin University of Technology, Nadbystrzycka 36B, 20-618 Lublin
Department of Computer Science

