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

72 T. Radványi Fields: ID Bigint (Identity) Primary key, a serial number given by the system. IDTszam Char(12) The costumers phone number. IDHMod Int The type of the call, foreign key to the HMod table, holds the connection between the tables. Hszam Char(12) The called phone number Hkezd Datetime The time of the calls begining Hbef Datetime The time of the calls end Hido lnt The time period of the call, its value is counted by a trigger. LogTab: We store the results of the tests in this table. The system automatically generates a record for every test in this table. Fields: ID int (Identity) Primary key, a serial number given by the system. Midopont Datetime The costumers phone number. Mkezd Datetime The tests beginning date and time Mbef Datetime End of test Mido Float Time period of the test MtipSQL Char (10) The type of SQL command that we test. In our case, the type is INSERT Rekordszám Bigint The number of inserted records during the test. TriggerAll Bit Counter to show that if every trigger was active or not. It is a factor in tlie systems load Mtip Char (10) Type of test Gepszam Smallint Number of machines in the test Cel Char(10) Destination datatable, Forg in our case Módszer Char(10) StoredProc/ADO comparison Triggers: two triggers belong to the forgalom table: forgJimod: Sets the time and type of the call after the record was inserted. It worth using the automatic data-definition as it can reduce the networks data-traffic.