Comparative Study: Performance of MVC Frameworks on RDBMS
Open Access
- 8 February 2024
- journal article
- research article
- Published by MECS Publisher in International Journal of Information Technology and Computer Science
- Vol. 16 (1) , 26-34
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.Keywords
This publication has 7 references indexed in Scilit:
- A comparative study of laravel and symfony PHP frameworksInternational Journal of Electrical and Computer Engineering (IJECE), 2019
- A new model for the selection of web development frameworks: application to PHP frameworksInternational Journal of Electrical and Computer Engineering (IJECE), 2019
- A Comparative study of PHP frameworks performanceProcedia Manufacturing, 2019
- Comparison of open source maturity modelsProcedia Computer Science, 2017
- Analysis and Practical Application of PHP Frameworks in Development of Web Information SystemsProcedia Computer Science, 2017
- design and implementation of web based on laravel framework2015
- An Empirical Study of the Evolution of PHP MVC Framework2014