Optimizing transaction data performance in database management systems
Abstract
One indicator of the quality an information system is speed data processing. A database's most common processing operations are adding, displaying, changing, and deleting data. The amount stored in database significantly impacts performance and, therefore, systems. update command changes some or all a table. works by retrieving table to be changed, entering new form, then sending it back database. often combined with condition specifying which rows must changed. This research experimental study that compares use procedure without procedure. results showed average time for was 348.896 milliseconds minimum category, 266.462 medium 279.543 maximum category. 297.132 747.670 1256.273 These suggest more efficient than one because can pre-compile SQL statement, reduces takes execute statement.