Peter Yuill
-
2016-10-13
- status: unread --> accepted
- Priority: 5 --> 1
public void deleteNode(Node node) throws SQLException { if (deleteStmt == null) { deleteStmt = con.prepareStatement(dml.getDeleteIndex()); } synchronized(deleteStmt) { try { deleteStmt.setLong(RTreeDml.ID_COL, node.getId()); } catch (SQLException sqle) { try { deleteStmt.close(); } catch (SQLException e) {} deleteStmt = null; throw sqle; } } }
DELETE is never executed in RTreeSessionDb.
So, index table never gets smaller (nodes of RTree are not removed from tree).