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 77 from the y — mx -}- b equation, we examine the value of the m parameter compared to each other. We did the definition of the equation with the method of the smallest squares, thats how we fit the line on the measured value pairs. The results from this count: mSP = 0.00150933 mADO = 0.00411515 As the graph shows the usage of the stored procedure is more even amd have a better rate of effectiveness: M = mADO/mSP = 2.7265 This shows that the usage of the stored procedure, in this case, gives a three times faster speed than the DataSet class ensured by the ADO.NET as a tool. An important note: If we would use the Update method not after the creation of the full record group in the memory, but after each and every record, this number could grow to a 10U times bigger. So if we are inserting thousands of records and the momenta! actualisation is not a must, than we should do it after the inserting of the records, but at least after greater groups. (b) WAN network, through ADSL connection Rcount ADO SP 1000 82.8625 39.9775 3000 248.073 120.266 5000 415.618 200.004 7000 583.255 286.318 10000 847.462 407.74 WAN, ADSL 512/128