International Journal of Information Technology and Computer Science (IJITCS)
IJITCS Vol. 16, No. 1, 8 Feb. 2024
Cover page and Table of Contents: PDF (size: 412KB)
Comparative Study: Performance of MVC Frameworks on RDBMS
Full Text (PDF, 412KB), PP.26-34
Views: 0 Downloads: 0
Author(s)
M. H. Rahman
1,*
M. Naderuzzaman
2
M. A. Kashem
1
B. M. Salahuddin
3
Z. Mahmud
3
Index Terms
Database, Framework, Insert, Update, Select, Delete
Abstract
The regular utilization of web-based applications is crucial in our everyday life. The Model View Controller (MVC) architecture serves as a structured programming design that developers utilize to create user interfaces. This pattern is commonly applied by application software developers to construct web-based applications. The use of a MVC framework of PHP Scripting language is often essential for application software development. There is a significant argument regarding the most suitable PHP MVC such as Codeigniter & Laravel and Phalcon frameworks since not all frameworks cater to everyone's needs. It's a fact that not all MVC frameworks are created equal and different frameworks can be combined for specific scenarios. Selecting the appropriate MVC framework can pose a challenge at times. In this context, our paper focuses on conducting a comparative analysis of different PHP frameworks. The widely used PHP MVC frameworks are picked to compare the performance on basic Operation of Relational databases and different type of Application software to calculate execution time. In this experiment a large (Big Data) dataset was used. The Mean values of insert operation in MySQL database of Codeigniter, Laravel, Phalcon were 149.64, 149.99, 145.48 and PostgreSQL database`s 48.259, 49.39, 45.87 respectively. The Mean values of Update operation in MySQL database of Codeigniter, Laravel, Phalcon were 149.64, 158.39, 207.82 and PostgreSQL database`s 48.24, 49.39, 46.64 respectively. The Mean values of Select operation in MySQL database of Codeigniter, Laravel, Phalcon were 1.60, 3.23, 0.98 and PostgreSQL database`s 1.95, 4.57, 2.36 respectively. The Mean values of Delete operation in MySQL database of Codeigniter, Laravel, Phalcon were 150.27, 156.99, 149.63 and PostgreSQL database`s 42.95, 48.25, 42.07 respectively. The findings from our experiment can be advantageous for web application developers to choose proper MVC frameworks with their integrated development environment (IDE). This result will be helpful for small, medium & large-scale organization in choosing the appropriate PHP Framework.
Cite This Paper
M. H. Rahman, M. Naderuzzaman, M. A. Kashem, B. M. Salahuddin, Z. Mahmud, "Comparative Study: Performance of MVC Frameworks on RDBMS", International Journal of Information Technology and Computer Science(IJITCS), Vol.16, No.1, pp.26-34, 2024. DOI:10.5815/ijitcs.2024.01.03
Reference
[1]Laaziri M, Benmoussa K, Khoulji S, Kerkeb ML, “A Comparative study of PHP frameworks performance”, Procedia Manufacturing, Vol. 32, pp. 864-871, 2019. DOI: 10.1016/j.promfg.2019.02.295
[2]Das R, Saikia LP, “Comparison of procedural php with codeigniter and laravel framework”, International Journal of Current Trends in Engineering & Research. Vol. 2, No. 6 pp. 42-48, 2016.
[3]Samra J., “Comparing performance of plain PHP and four of its popular frameworks”, Depaartment of Computer Science, Linnaeus University, 2015.
[4]He RY., “Design and implementation of web based on Laravel framework”, In 2014 International Conference on Computer Science and Electronic Technology (ICCSET 2014), pp. 301-204, 2015. DOI: 10.2991/iccset-14.2015.66
[5]Prokofyeva N, Boltunova V., “Analysis and practical application of PHP frameworks in development of web information systems”, Procedia Computer Science, Vol. 104, pp. 51-56, 2017. DOI: 10.1016/j.procs.2017.01.059
[6]Olanrewaju RF, Islam T, Ali NA. An empirical study of the evolution of PHP MVC framework. In Advanced Computer and Communication Engineering Technology: Proceedings of the 1st International Conference on Communication and Computer Engineering, pp. 399-410, 2015. DOI: 10.1007/978-3-319-07674-4_40
[7]Database. Available at: https://www.goldenfast.net/blog/apa-itu-database. Accessed on 10th January, 2023.
[8]Guy Karlebach, Leigh Carmody, Jagadish Chandrabose Sundaramurthi, Elena Casiraghi, Peter Hansen, Justin Reese, Chris J Mungall, Giorgio Valentini, Peter N. Robinson, “An algorithmic framework for isoform-specific functional analysis”, Biorxiv, 2022-05. DOI: 10.1101/2022.05.13.491897
[9]PostgreSQL. Available at: https://appypie.com/connect/apps/ postgresql. Accessed on 10th January, 2023.
[10]Prokofyeva N, Boltunova V., “Analysis and practical application of PHP frameworks in development of web information systems”, Procedia Computer Science, Vol.104, pp. 51-56, 2017. DOI: 10.1016/j.procs.2017.01.059
[11]Laaziri M, Benmoussa K, Khoulji S, Larbi KM, El Yamami A, “A comparative study of laravel and symfony PHP frameworks”, International Journal of Electrical and Computer Engineering (IJECE). Vol. 9, No. 1, pp:704-12, 2019. DOI: 10.11591/ijece.v9i1. pp704-712
[12]Benmoussa, Khaoula, Majida Laaziri, Samira Khoulji, Mohamed Larbi Kerkeb, and Abir El Yamami. "A new model for the selection of web development frameworks: application to PHP frameworks." International Journal of Electrical & Computer Engineering, Vol-9, No. 1, pp. 695-703, 2019. DOI: 10.11591/ijece.v9i1. pp695-703
[13]Nylén. H., “PHP Framework Performance for Web Development Between Codeigniter and CakePHP”, Bachelor Thesis, School of Computing Blekinge Institute of Technology, Sweden, 2012.
[14]Prokofyeva N., Boltunova V., “Analysis and Practical Application of PHP Frameworks in Development of Web Information Systems”, Procedia Computer Science, Vol. 104, pp. 51–56, 2016. DOI: 10.1016/j.procs.2017.01.059
[15]Umm-E-Laila, A. Zahoor, K. Mehboob, S. Natha, “Comparison of open source maturity models”, Procedia Computer Science, Vol. 111, pp. 348–354, 2017. DOI:10.1016/j.procs.2017.06.033