Performance Evaluation of PHP Data Object and Native Database Connection for CRUD Optimization Across MySQL, PostgreSQL, and MySQLite

Warto Warto; Anas Azhimi Qalban; Yusuf Heriyanto; Putra Aditya Priyono

Authors

Warto Warto Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto
Anas Azhimi Qalban Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto
Yusuf Heriyanto Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto
Putra Aditya Priyono Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto

Abstract

This study presents an experimental performance evaluation of the PHP Data Object (PDO) compared to native database connections, specifically mysqli and pg_connect, in executing CRUD operations across three major relational database management systems: MySQL, PostgreSQL, and SQLite. The research aims to determine the extent to which PDO’s abstraction layer influences execution efficiency, memory utilization, and scalability in database-driven applications. Using datasets of varying sizes—1.000, 10.000, 100.000, and 1.000.000 records—each CRUD operation was benchmarked under identical system configurations. The aggregated results indicate that PDO exhibits a lower overall mean execution time of 82,54 ms with a standard deviation of 31.54, compared to Native implementations at 88,22 ms with a standard deviation of 34,28. PDO also demonstrates slightly lower average memory usage, 7,29 MB, whereas Native 7,96 MB and smaller dispersion, 0,61 MB, and Native 0,83 MB across configurations. Inferential statistical analysis using a paired t-test further indicates that the observed differences between PDO and Native implementations are statistically significant (p < 0,0001) under the evaluated experimental configurations. These findings suggest that PDO can provide comparable performance efficiency while maintaining the architectural advantages of abstraction and portability in PHP-based web systems.

Author Biographies

Warto Warto, Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto

Department of Informatics, Faculty of Science and Technology

Anas Azhimi Qalban, Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto

Department of Informatics, Faculty of Science and Technology

Yusuf Heriyanto, Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto

Department of Informatics, Faculty of Science and Technology

Putra Aditya Priyono, Universitas Islam Negeri Prof. K.H. Saifuddin Zuhri Purwokerto

Department of Informatics, Faculty of Science and Technology

References

[1] J. F. Zimmermann, “Data Management and Processing in Toxicoinformatics: From Chemical Databases to Automatic Extraction of Unstructured Resources.” Computational Systems Toxicology, 2015. doi: 10.1007/978-1-4939-2778-4_5.

[2] A.-M. Bonteanu and C. Tudose, “Performance Analysis and Improvement for CRUD Operations in Relational Databases from Java Programs Using JPA, Hibernate, Spring Data JPA,” Appl. Sci., Mar. 2024, doi: 10.3390/app14072743.

[3] D. Zmaranda, L. L. Pop-Fele, C. Gyorödi, R. Gyorödi, and G. Pecherle, “Performance Comparison of CRUD Methods Using NET Object Relational Mappers: A Case Study’,” Int. J. Adv. Comput. Sci. Appl., vol. 11, no. 1, pp. 55–65, 2020, doi: 10.14569/ijacsa.2020.0110107.

[4] D. Popel, “Learning PHP Data Objects.” 2007.

[5] S. O. and E.-Y. B., “Neutralizing SQL Injection Attack on Web Application Using Server Side Code Modification,” Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol., May 2019, doi: 10.32628/CSEIT1952339.

[6] M. Sendiang, O. Mellolo, and M. Langie, “Implementation pdo parameterized query to prevent sql injection,” Int. J. Comput. Appl., vol. 149, no. 11, pp. 27–31, 2016.

[7] E. Sierra and U. L. Yuhana, “Optimizing Software Development through Data Access Speed using Object-Relational Mapping (ORM) on Credit Risk Application,” 2023 3rd Int. Conf. Smart Cities Autom. Intell. Comput. Syst. ICON-SONICS, pp. 201–206, Dec. 2023, doi: 10.1109/icon-sonics59898.2023.10435255.

[8] T. Taipalus, “Database management system performance comparisons: A systematic literature review,” J. Syst. Softw., vol. 208, p. 111872, 2024, doi: https://doi.org/10.1016/j.jss.2023.111872.

[9] A. Pavlo and M. Aslett, “What’s Really New with NewSQL?,” SIGMOD Rec, vol. 45, pp. 45–55, Sep. 2016, doi: 10.1145/3003665.3003674.

[10] R. Jiménez-Peris, D. Burgos-Sancho, F. Ballesteros, M. Patiño-Martínez, and P. Valduriez, “Elastic scalable transaction processing in LeanXcale,” Inf Syst, vol. 108, p. 102043, Mar. 2022, doi: 10.1016/j.is.2022.102043.

[11] W. B. Demilie and F. G. Deriba, “Detection and prevention of SQLI attacks and developing compressive framework using machine learning and hybrid techniques,” J. Big Data, vol. 9, pp. 1–30, Dec. 2022, doi: 10.1186/s40537-022-00678-0.

[12] S. V. Salunke and A. Ouda, “A performance benchmark for the postgresql and mysql databases,” Future Internet, vol. 16, no. 10, p. 382, 2024.

[13] R. Nambiar and M. Poess, “Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things,” vol. 9508, Jan. 2016, doi: 10.1007/978-3-319-31409-9.

[14] M. Santoro, L. Vaccari, D. Mavridis, R. Smith, M. Posada, and D. Gattwinkel, “Web application programming interfaces (apis): General purpose standards, terms and European commission initiatives,” Eur Comm. Louxemb. Louxemb. UK Tech Rep JRC118082, 2019.

[15] G. Allen and M. Owens, “The Definitive Guide to SQLite,” May 2006, doi: 10.1007/978-1-4302-3226-1.

[16] K. Gaffney, M. Prammer, L. Brasfield, D. Hipp, D. Kennedy, and J. Patel, “SQLite,” Proc. VLDB Endow., Aug. 2022, doi: 10.1007/978-1-4302-0367-4_22.

[17] C. Li, Z. Zang, H. Lin, and H. Li, “Research on Display and Storage of Raster Data Based on Android Platform,” 2018 Fifth Int. Workshop Earth Obs. Remote Sens. Appl. EORSA, pp. 1–4, Jun. 2018, doi: 10.1109/eorsa.2018.8598571.

[18] C. Győrödi, D. Dumşe-Burescu, R. Győrödi, D. Zmaranda, L. Bandici, and D. Popescu, “Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases,” Appl. Sci., Jul. 2021, doi: 10.3390/app11156794.

[19] S. Mo, Y. Zhao, Z. Bao, Q. Xu, C. Yang, and G. Cong, “RankPQO: Learning-to-Rank for Parametric Query Optimization,” Proc VLDB Endow, vol. 18, pp. 863–875, Nov. 2024, doi: 10.14778/3712221.3712248.

[20] L. Doshi, “Kepler: Robust Learning for Parametric Query Optimization,” Proc. ACM Manag. Data, vol. 1, pp. 1–25, May 2023, doi: 10.1145/3588963.

[21] R. Zhu, “Lero: A Learning-to-Rank Query Optimizer,” Proc VLDB Endow, vol. 16, pp. 1466–1479, Feb. 2023, doi: 10.14778/3583140.3583160.

[22] J. Lao, “GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization,” ArXiv, vol. abs/2311.03157, Nov. 2023, doi: 10.14778/3659437.3659449.

[23] J. Smith and D. Smith, “Database abstractions,” ACM Trans. Database Syst. TODS, vol. 2, pp. 105–133, Jun. 1977, doi: 10.1145/320544.320546.

[24] M. Natti, “Managing Connections Efficiently in PostgreSQL to Optimize CPU, I/O and Memory Usage,” Int. J. Sci. Res. Arch., Apr. 2025, doi: 10.30574/ijsra.2025.15.1.0650.

[25] J. Spray, R. Sinha, A. Sen, and X. Cheng, “Building Maintainable Software Using Abstraction Layering,” IEEE Trans. Softw. Eng., vol. 48, pp. 4397–4410, Nov. 2022, doi: 10.1109/TSE.2021.3119012.

[26] R. S. Pressman and B. R. Maxim, Software Engineering A PRACTITIONER’S APPROACH. McGraw-Hill, 2020.

[27] L. Ju, A. Yadav, A. Khan, A. P. Sah, and D. Yadav, “Using Asynchronous Frameworks and Database Connection Pools to Enhance Web Application Performance in High-Concurrency Environments,” 2024 8th Int. Conf. -SMAC IoT Soc. Mob. Anal. Cloud -SMAC, pp. 742–747, Oct. 2024, doi: 10.1109/i-smac61858.2024.10714639.