Choosing the optimal database system to create a CRM system
Article Sidebar
Open full text
Issue Vol. 26 (2023)
-
Augmenting The Cloud Environment Security Through Blockchain Based Hash Algorithms
1-6
-
Comparison of an effectiveness of artificial neural networks for various activation functions
7-12
-
Performance analysis of user interface implementation methods in mobile applications
13-17
-
Comparative analysis of web applications implemented in: PHP and Python
18-22
-
Comparative analysis of social media accessibility
23-28
-
Comparative analysis of transfer protocols asynchronous messages on systems queuing
29-32
-
Usability analysis of advertising websites interfaces with the use of the universal design principles
33-41
-
A comparative analysis of contemporary integrated java environments
42-47
-
Choosing the optimal database system to create a CRM system
48-53
-
Analysis of the usability and accessibility of public transport online timetables in selected cities in Poland
54-62
-
Analysis of configuration distribution methods in service application environments
63-67
-
A Researching users' knowledge in the Field of Instant Messengers Security
68-74
-
Performance analysis of working with databases with Spring and Symfony
75-82
-
The analysis of Blender open-source software cloth simulation capabilities
83-87
-
Comparative analysis of selected programming frameworks dedicated to SPA applications
88-92
-
Comparative analysis of code execution time by C and Python based on selected algorithms
93-99
Main Article Content
DOI
Authors
Abstract
MSSQL, MySQL and PostgreSQL are some of the most popular databases. The selection of the database for the creation of a CRM system is based mainly on the assessment of its effectiveness in terms of speed. The article aims to choose the optimal database system to create an effective CRM system. The literature review led to the hypothesis that MSSQL will be the fastest. A series of experiments using the app served as a test. During the research, a series of experiments were carried out using the order processing module, which is part of a larger CRM system aimed at the e-commerce industry. Each query was measured 10 times, the result averaged. The research results did not confirm the hypothesis about the speed and significant advantage of the MSSQL database. The results showed the advantage of PostgreSQL over other databases.
