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

Acta Academiae Paedagogicae Agriensis, Sectio Mathematicae 31 (2004) ^"25 129 EXAMINATION OF THE MSSQL SERVER FROM THE USER'S POINT OF VIEW CONSIDERING DATA INSERTION Tibor Radványi (Eger, Hungary) Abstract. In this paper we summarize the experiences of the partial effectiveness examination made on the MSSQL server. We examined the effectiveness of the insert sample databases on the server. The client program was written in C++ language, in the Visual.NE T system. We have done the examination of the data insert both from single—and multiclient environment. The examination contains insert options of the ADO.NET subsystem given by the .NET system - and insert options of stored procedures that were stored on the MSSQL server. These comparisons were extended with the analysis of the different network speed environments. Tests were made on high speed intranet and on Internet, ADSL (512 kbs), connection. We think that the profound and various examination of the database servers is very important. Here we relate test results that can be usable either in research in connection with database servers or in practical usage of the same systems. AMS Classification Number: 68P30, 68P10 I. Introduction The testing of the database systems and the measuring of their effectiveness lias an important part in todays research fields [1]. When talking about systems with great data traffic, the insert of data is an especially resource-required operation. In the case of the benchmark test both the servers and the clients software options must be kept in view [2], [3]. Our test expressly closes and examines the functioning of the database from the clients side. Comparison means the collation of the different opportunities given by the programming environment during the creation of the client software. The first task is the recording of environment that influences the test results such as the size of the DataSet, the complexity of the SQL commands, hardware/software environment, the expandantion and capability of the network [1]. The goal of our test is to compare two data uploading methods given by the new .NET technology. We can only do this with an appropriately built program on the clients side and with the measuring of the results 011 the clients side. The client program was made in the Visual.NET system, in C++ language. To reach the database, the ADO.NET technology is a new and effective tool. In order to get best performance we used the Microsofts recommendations and research results [2], [5],