Comparison of C# and Python programming languages in terms of performance and coding on SQL server DML operations

• Main Author: Ataturk University
• Other Authors: Mahmut, YEŞİLYURT, Yusuf Ziya, AYIK
• Format: Article in Journal/Newspaper
• Language: unknown
• Published: Ataturk University 2024
• Subjects: DML
• Online Access: https://doi.org/10.5281/zenodo.12547651

Nowadays, there are several computer programming languages and database management systems, and they have advantages and disadvantages one over another. Databases are essential components of computer programs, regardless of their language. Thanks to databases, computer programs record the data that they need or produce and perform the given tasks by retrieving these data when necessary. For a computer program to run efficiently and quickly, it is essential that both the database and the computer program are well structured. In this study, C# and Python languages, which are among the most widely used programming languages out of these various programming languages, have been evaluated in terms of transaction performance and the amount of code that needs to be written to perform SQL DML (Data Manipulation Language) operations such as INSERT, SELECT, UPDATE, DELETE operations and print the results of the operation on the screen via MSSQL database,1 which is one of the most widely used database management systems. In terms of processing performance, it was observed that neither programming language provided a significant superiority over the other, although mathematically Python language seems to have performed better when looking at the processing times. In terms of code size and readability, although C# is generally considered to be a more readable language in terms of code readability, in the context of the programs written for this study, there was no difference between the two programming languages in terms of code readability. In terms of code size, Python provided a clear superiority. As a result, it has been determined that both languages have superior features compared to each other, and that there is no definite superiority between these two languages that can be a reason for preference over each other in DML operations. The choice of language should be based on the requirements of the project, the ecosystem and the skills of the team.