Az Eszterházy Károly Tanárképző Főiskola Tudományos Közleményei. 2004. Sectio Mathematicae. (Acta Academiae Paedagogicae Agriensis : Nova series ; Tom. 31)

RADVÁNYI , T. , Examination of the MSSQL server considering data insertion

70 T. Radványi 2. Hardware and software systems that were used during the test A server computer that was indispensable for the test was installed 011 the Computing Department of the Károly Eszterházy College. This machine gave us the opportunity that show acceptable performance on the servers side and dont go off from the opportunities given by ensured by real user environments. As the formation of the current environment greatly influences the test results, the most important information for us are not the exact time information, but the differences shown between usage of the different programming tools, so we have to examine the proportion of the measured time values. The parameters of the server and the client machines can be found in the appendix. The program development was done on the C++ language that is part of the Microsoft Visual Studio .NET 2003. The database can be found on the Microsoft SQL Server 2000 Enterprise Edition. 3. The database During the test the following database has beert used: Subtables: these simple tables contain basic data that are used for the random filling of the table with the subscriptors data: (sHelysegnev, sVezeteknev, sKeresztnev, sUtcanev). These have no role in the test, they help to create the appropriate environment. As this system is a simplified model of a real system, the starting data information about the subscriptors are generated by a procedure that uses the subtables as a help. These subtables do not contribute to the database 011 the classical way, they do not take part in the test, they have no influence on its results so their connection to the database through keys and references is superfluous and harmful. What still indicates their usage is the nearly 10 million generated record, that can be used later to test requests and to get readable results and lists that are true to life. The test is influenced by the data of the following tables, these are the ones that give results. Elofiz: stores the data of the telephon Companys subscriptors. These data will be generated by the help of the subtables.