Soham Desai

at which point size of .lob file will be shrink? because as your mention step i create new DB with below settings. hsqldb.lob_compressed=true; hsqldb.log_data=true; hsqldb.log_size=1; hsqldb.defrag_limit=2 and i checked everytime file size has been increased. even if i delete data which contains lobs. run checkpoint and insert new data or update data in DB with lobs. i observed every time size is increased and even it is not used free space also. please is there any more settings regarding this issue...

I have create fresh HSQLDB database with below settings. hsqldb.lob_compressed=true; hsqldb.log_data=true; hsqldb.log_size=1; hsqldb.defrag_limit=2 now it is reflacted in script file also and CHECKPOINT also perform after reached log file to 1MB. but after checkpoin my LOB file is not shrink. so i found that SYSTEM_LOB has few procedure as mention below. ALLOC_BLOCKS ALLO_SINGLE_BLOC CONVERT_BLOC CREATE_EMPTY_BLOC DELETE_BLOCKS DELETE_LOB DELETE_UNSUSED DELETE_UNUSED_LOBS DIVIDE_BLOCK MERGE_EMPTY_BLOCKS...

Thank you for your help. few questions more questions i have to ask you. i have already download hsqldb-2.4.1.zip from below link https://sourceforge.net/projects/hsqldb/files/ is there any step to migrate hsqldb from 2.3.4 to 2.4.1. or directaly replace jar file in project. i have to call checkpoint defrag after insert/update and delete operation. or is there any configuration in hsqldb to call checkpoint defrag after crud operation itself. how to check lobs are located at end of file or not. Thank...

please give me link for dowload HyperXtremeSQL latest jar . and "if there are no lobs left in the end part" meance can you explain in detail. Thank you for your quick help

Reduced .lob file size

but is there any other way to reduce file size without deleting lob data? because it is our client data so could not delete.

but is there any other way to reduce file size without deleting lob data? because it is our client data so could not delete.