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

Examination of the MSSQL server considering data insertion 73 forg_hbef

: Counts the calls the time period after the Hívás befejezése field was filled, than it puts it to the records appropriate column. 4. The program The client programs technology uses the latest Microsoft development, the Visual.Net system. The software was written 011 C++ language, that gives a flexible tool to do the appropriate tests. As our test included the Microsoft MSSQL servers data-insert partition, we chose the DataSet solution from the options of the DataReader on-line read-only connection and the DataSet off-line solution. The DataSet class communication with the SQL server is well represented by the picture below. The program in its current state from the tests view point uses two different datahandling method. One amplifies the Rows Collection of the SqlDataSets DataTable class given by the ADO.NET frame with new records and at the end of the amplification, it uses the SqlDat.aAdapter class Update method to actualise the content of the database. The other does the same by using stored procedures. Practically, holding the connection with the database lays on ADO.NET bases in both cases, but in the last case the procedures stored on the server are responsible for the uploading that we call with parameters by the SqlCommad class help. When using a stored procedure for uploading we only need the SQLCornmand class with right parameters and the running of the command. So the goal of the test is to compare the 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 on the clients side. The test includes the examination of the whole system, as it.ll seem from the results shown later, the results are unambiguously and consistently influenced by the speed of the network and the servers software and hardware preparation. As our goal is the test on the clients side, the results are valid to this given system. Inasmuch as we would only test the performance of the SQL server, we could only make test with programs run 011 the server to exclude the clients and the network. This is possible, but the goal of the article is not that. The test of the two methods was our goal, and well show the results of these now. 5. Tests and results With the tests, we kept in view that many factors may influence the results due to the complexity of the system. A test result row starts with the selection of given method (Stored Procedures (SP) or DataSet (ADO)) and with the definition records number that will inserted. We repeat such a test for fifty times to exclude errors. We did approximately 800 tests with t he different record numbers. The test results went through an examination before they were averaged and the once or twice occurred extreme results didnt get in to the average. These deviations always