hsqldb - HSQL database storage format -
i starting usage of hsql database , i'm misunderstanding storage format of data.
have made simple test program creating entity via hibernate. used file-based standalone in-process mode of hsql.
got file of data:
testdb.script
set database unique name hsqldb52b647b0b4 // set database lines skipped insert person values(1,'peter','uuu') insert person values(2,'nasta','kuzminova') insert person values(3,'peter','sagan') insert person values(4,'nasta','kuzminova') insert person values(5,'peter','sagan') insert person values(6,'nasta','kuzminova')
as understand when lot of data, of stored such sql script , executed every time of database startup , kept in memory?
the insert statements in .script
file memory tables of database.
if create table create cached table ...
or change memory table cached set table <name> type cached
data table stored in .data
file , there no insert statements in .script
. file.
Comments
Post a Comment