Due to the large amount of data in the audit log table, a single INSERT statement will usually fail because the data per transaction exceeds the log file size of the database system.
因为审核日志表格里有大量的数据,单独的insert语句通常会失败,这是因为每个事务的数据超过了数据库系统里的日志文件的容量。
For example, a sales table fragmented by transaction date column such that new rows are added each month to store current month sales data.
例如,按照事务日期列分段的销售表,每个月都将添加新的行来存储当月的销售数据。
HSQLDB keeps all table and index data in memory, saving all SQL statements issued into a file named database.script, which also ACTS as the transaction log.
HSQLDB将所有表和索引数据放在内存中,将所有发出的sql语句保存到一个名为database . script的文件中,该文件同时也充当着事务日志的角色。
应用推荐