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

Abstract

Nowadays, there is a wide variety of computer programming languages and database management systems, and these various programming languages and database management systems have advantages and disadvantages over each other. Regardless of the language, databases are an indispensable component of a computer program. Thanks to databases, computer programs store the data they need or produce and perform the given tasks by accessing these data when necessary. For a computer program to run efficiently and quickly, both the database and the computer program must be well-structured. In this study, C# and Python languages, which are the most widely used programming languages among these various programming languages are evaluated in terms of processing performance and the amount of code that needs to be written to perform data manipulation operations (INSERT, SELECT, UPDATE, DELETE) over the MSSQL database, which one of the most widely used database management systems

Keywords

• C#
• Python
• MSSQL
• DML Operations
• Code Writing
• Performance

References

1. 1. Stackoverflow.com. Stack Overflow Developer Survey 2022. Stack Overflow. https://survey.stackoverflow.co/2022#most-popular- technologies-misc-tech. Accessed May 11, 2024.
2. 2. Setiyadi D. Database System Development Life Cycle (DSDLC) on System Libraries for Data Manipulation Language (DML) Using SQL Server 2008. J Mantik. 2021;5(2):1065-1066. https://www.ejournal.iocscience.org/index.php/mantik/a rticle/view/1448/1032. Accessed May 1, 2024.
3. 3. Hakim Lubis J, Muisa Zamzami E. Relational Database Reconstruction from SQL to Entity Relational Diagrams. J Phys Conf Ser. 2020;1566(1). doi:10.1088/1742- 6596/1566/1/012072.
4. 4. Codd EF. A Relational Model of Data for Large Shared Data Banks. Commun ACM. 1970;13(6):377-387. doi:10.1145/362384.362685.
5. 5. Microsoft Learn. ACID Properties - Win32 apps | Microsoft Learn. https://learn.microsoft.com/en- us/windows/win32/cossdk/acid-properties. Accessed May 11, 2024.
6. 6. Taylor P. Most popular relational DBMS 2022 | Statista. https://www.statista.com/statistics/1131568/worldwide- popularity-ranking-relational-database-management- systems/. Accessed May 11, 2024.
7. 7. Azure Microsoft. NoSQL Database - What is NoSQL? https://azure.microsoft.com/tr-tr/resources/cloud- computing-dictionary/what-is-nosql-database/. Accessed May 11, 2024.
8. 8. Amazon.com. NoSQL Nedir? | Non-Relational Databases, Flexible Schema Data Models | AWS. https://aws.amazon.com/tr/nosql/. Accessed May 11, 2024.

9. 9. Bektaş G. The Importance of Data Management and the Role of NoSQL Databases: ACID, CAP, and BASE Concepts and Principles. https://medium.com/@bektasguner772/the-importance- of-data-management-and-the-role-of-nosql-databases- acid-cap-and-base-concepts-and-principles- e7c572742098. Accessed May 11, 2024.
10. 10. Innuy. List of Best and Most Popular NoSQL Database 2022. https://www.innuy.com/blog/list-of-best-and-most- popular-nosql-database-2022/. Accessed May 11, 2024.
11. 11. Saralıoğlu E. Python Programlama Dili Kullanılarak Uzaktan Algılama Amaçlı Arayüz Tasarımı [master’s thesis]. Karadeniz Technical University; 2015.
12. 12. Ayvaz U, Çoban A, Gürüler H, Peker M. Python Dilinin Öznitelikleri, Programlama Eğitiminde ve Yazılım Dünyasındaki Yeri. Akad Bilişim. 2016;1-6.
13. 13. Summerfield M. Programming in Python 3: A Complete Introduction to the Python Language. 2nd ed. http://ifile.it/qx63lw/ebooksclub.org Programming_in_ Python_3 A_Complete_Introduction_to_the_Python_La nguage 2nd_Edition_.pdf. Accessed May 9, 2024.
14. 14. Scarlett R. Why Python keeps growing, explained - The GitHub Blog. https://github.blog/2023-03-02-why-python- keeps-growing-explained/. Accessed May 11, 2024.
15. 15. Python.org. Python 3 Documentation. https://docs.python.org/. Accessed May 11, 2024.
16. 16. Kimmel P. Advanced C# Programming. McGraw- Hill/Osborne; 2002.
17. 17. Microsoft Learn. C# Guide .NET managed language | Microsoft Learn. https://learn.microsoft.com/en- us/dotnet/csharp/. Accessed May 12, 2024.
18. 18. Riches O. GitHub - oriches/faker-cs: C# port of the Ruby Faker gem. https://github.com/oriches/faker-cs. Accessed May 11, 2024.