Yener Sönmez, O. Bayat, Tugce Balli Altuglu, A. Duru
{"title":"基于数据库查询的PHP-ASP Web应用程序性能比较","authors":"Yener Sönmez, O. Bayat, Tugce Balli Altuglu, A. Duru","doi":"10.1145/2832987.2833054","DOIUrl":null,"url":null,"abstract":"In the concept of the study, an empirical comparison of PHP and ASP technologies are performed. The comparison is based on the execution speed of three simple scripts. In the first phase, ASP and PHP are compared using a script that contains a for loop. Several iterations are performed starting from ten thousand to ten million and execution times are measured. Each experiment has been used for 10 times and average values of execution speed are computed. In the second phase, execution speed of PHP-MySQL and ASP-MSSQL combinations are compared. An \"insert\" and a \"select\" query using a single database table are used in a for loop. Minimum Iteration number is selected as 100 while the maximum was set to 100000 for \"insert\" and one million for \"select\" queries. It was observed that PHP-MySQL combination may have a better performance than ASP.net-MSSQL Server, in the case of both SQL queries.","PeriodicalId":416001,"journal":{"name":"Proceedings of the The International Conference on Engineering & MIS 2015","volume":"20 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2015-09-24","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"5","resultStr":"{\"title\":\"Performance Comparison of PHP-ASP Web Applications via Database Queries\",\"authors\":\"Yener Sönmez, O. Bayat, Tugce Balli Altuglu, A. Duru\",\"doi\":\"10.1145/2832987.2833054\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"In the concept of the study, an empirical comparison of PHP and ASP technologies are performed. The comparison is based on the execution speed of three simple scripts. In the first phase, ASP and PHP are compared using a script that contains a for loop. Several iterations are performed starting from ten thousand to ten million and execution times are measured. Each experiment has been used for 10 times and average values of execution speed are computed. In the second phase, execution speed of PHP-MySQL and ASP-MSSQL combinations are compared. An \\\"insert\\\" and a \\\"select\\\" query using a single database table are used in a for loop. Minimum Iteration number is selected as 100 while the maximum was set to 100000 for \\\"insert\\\" and one million for \\\"select\\\" queries. It was observed that PHP-MySQL combination may have a better performance than ASP.net-MSSQL Server, in the case of both SQL queries.\",\"PeriodicalId\":416001,\"journal\":{\"name\":\"Proceedings of the The International Conference on Engineering & MIS 2015\",\"volume\":\"20 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2015-09-24\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"5\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the The International Conference on Engineering & MIS 2015\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/2832987.2833054\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the The International Conference on Engineering & MIS 2015","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/2832987.2833054","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Performance Comparison of PHP-ASP Web Applications via Database Queries
In the concept of the study, an empirical comparison of PHP and ASP technologies are performed. The comparison is based on the execution speed of three simple scripts. In the first phase, ASP and PHP are compared using a script that contains a for loop. Several iterations are performed starting from ten thousand to ten million and execution times are measured. Each experiment has been used for 10 times and average values of execution speed are computed. In the second phase, execution speed of PHP-MySQL and ASP-MSSQL combinations are compared. An "insert" and a "select" query using a single database table are used in a for loop. Minimum Iteration number is selected as 100 while the maximum was set to 100000 for "insert" and one million for "select" queries. It was observed that PHP-MySQL combination may have a better performance than ASP.net-MSSQL Server, in the case of both SQL queries.