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

76 T. Radványi The curve that took shape can again be described with a linear equation. After the counting, the following factors remain: inSP = 0.040665 mADO = 0.084036 As the graph shows, the usage of the stored procedure is more even and have a better rate of effectiveness: M = mADO/mSP = 2.06652 The redundancy of the rate of effectiveness can be influenced by the different speed of the network and by its stability. 6. Conclusions, further directions The programming of databases, its access from application sofwares is a wide spread and major problem in many places that occurs in many fields of live. The first step of handling data their storage a method that occurs in every system, uses great resources from the given frame at some places. Our goal with this test was to examine the reducing possibilities in the case of a wide spread system. The test results unambiguously supports that the systems inserting effectiveness can be greatly improved if we use the options given by the SQL servers, the use of the stored procedures, even in the case of such tasks that seem to be easily solved by other methods. We will expand the examination of the insert method to the Oracle, the IBM DB2 and to the lnterbase SQL servers. We will not only do this by comparing the different methods, but will also compare the test results to find the most effective data insert method on the above mentioned servers. For a more flexible and easier handling, we also need to upgrade the client program written in C++ language. It 11 be a task to create different classes for the different database-handling devices, for the different methods. All classes must have the same procedures for in the main program, we only need to use an object of the appropriate class instead of the conditional, that are getting more and more complex. The timing system should be altered to a form, where the timing should not be set again and again on each and every machine, be we only need to put them into timing mode. The actual timings would appear centrally in the database, and the timed programs would continuously check if there is a task for them. This would greatly improve and mke the testing easier, even in the case of a small number of computers, and it is obligatory for a large number of clients.