Verify the Effectiveness of the Intelligent Data Layer on Different Hardware Configurations

Abstract

The article builds on research focused on the design and construction of an Intelligent Data Layer (IDL) using Object-Relational Mapping (ORM) frameworks, which can sometimes be inefficient. The aim of this article is to verify whether IDL functions as an optimization technique in different hardware environments. Previous research has shown that IDL can significantly improve the performance of applications, especially in loading and processing large amounts of data. However, this improvement was observed on standard test hardware. Therefore, we conducted this testing, which includes tests on different hardware configurations, specifically a server and a test workstation. The tests focus on data retrieval speed, memory usage efficiency, and overall application performance when using IDL compared to traditional approaches. The results of the tests will help determine whether IDL is a universal optimization technique or whether its effectiveness depends on specific hardware conditions. This knowledge is crucial for us for the future development and deployment of IDL in real-world applications. The experiments were conducted in an environment with an Nginx web server, PHP, and a MySQL database. The tested implementation runs on Symfony and Doctrine. For the individual experiments, a relational database model from previous work was used, which included tables with varying numbers of rows.