InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
The Size Of The .data File Grows In Operation Although The Total Row Count For Cached Tables Has Not Gone Up. Why? |
|
Answer» HSQLDB tracks only up to a fixed NUMBER of the empty SPACES left after DELETE or during UPDATE OPERATIONS. If the delete rate is higher than insert rate, or large number of rows are updated in a single query, then some spaces are left empty. Both CHECKPOINT DEFRAG and SHUTDOWN COMPACT commands will remove the empty spaces. In version 2.3.0 empty spaces are tracked better and DEFRAG will be performed automatically, based on a user-defined property. HSQLDB tracks only up to a fixed number of the empty spaces left after DELETE or during UPDATE operations. If the delete rate is higher than insert rate, or large number of rows are updated in a single query, then some spaces are left empty. Both CHECKPOINT DEFRAG and SHUTDOWN COMPACT commands will remove the empty spaces. In version 2.3.0 empty spaces are tracked better and DEFRAG will be performed automatically, based on a user-defined property. |
|