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

74 T. Radványi had cause that, was independent from the test (hardware error, non-planned load 011 the server). We stopped all other resource requiring processes on the server for the tests duration. No other SQL servers (Oracle, MySQL) were running. This was the way we tried to ensure the most undisturbed conditions. Signs, abbreviations: Rcount: number of inserted records; SP: usage of Stored Procedures; ADO: usage of DataNet. (a) Local Area Network, one client machine (results in seconds) Rcount SP ADO 10000 14.26565 24.2969 20000 30.9583 52.224 30000 44.401 113.5 40000 59.4896 174.3 50000 71.32825 216.016 60000 89.25 289.2373 70000 106.37 330.556914 80000 121.474 371.876529 90000 129.271 406.723 100000 159.161 289.2373 The curve that took shape can be approximated by a linear equation, where,