Abstract
Research to test the performance of inner joint queries between MariaDB and the PostgreSQL database management system. Inner joint queries have the same output in MariaDB and PostgreSQL DBMS. This study aims to provide a comparative analysis of the response time performance of MariaDB and PostgreSQL databases in the use of inner join queries. The research test was conducted with 1,050,000 records using 21 response time data collection scenarios ranging from 50,000 data to 1,050,000 data collection with multiples of 50,000 data. The PostgreSQL DBMS was found to have better response times than MariaDB in all test scenarios. The results of the regression analysis to test the effect of using the F-test show that there is a significant effect on the amount of data and the relationship together on the response time in MariaDB and PostgreSQL. Then the T-test is carried out to strengthen the results of the study that PostgreSQL has a faster response time than MariaDB, testing 1 combined relationship shows a significant difference, testing 2 combined relationships shows a significant difference and testing 3 combined relationships shows a significant difference.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
