db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <derby-...@db.apache.org>
Subject [jira] Closed: (DERBY-509) DERBY-132 resolved ? Table not automatically compressed
Date Wed, 17 Aug 2005 00:21:55 GMT
     [ http://issues.apache.org/jira/browse/DERBY-509?page=all ]
     
Mike Matrigali closed DERBY-509:
--------------------------------

    Resolution: Invalid

This is the current expected behavior.  Full compress is not done automatically, at 
the page level deleted space is reused by  subsequent inserts. This test case is
the worst case scenario as only every 3rd or 5th row is deleted.  I will file a separate
enhancement  to somehow  automatically run compress table.  

> DERBY-132 resolved ? Table not automatically compressed
> -------------------------------------------------------
>
>          Key: DERBY-509
>          URL: http://issues.apache.org/jira/browse/DERBY-509
>      Project: Derby
>         Type: Bug
>     Versions: 10.1.1.0
>  Environment: JDK 1.4.2, JDK 1.5.0,
> Windows XP
>     Reporter: Volker Edelmann

>
> I tried a test-program that repeatedly inserts a bunch of  data into 1 table and repeatedly
deletes a bunch of data. 
>     	derby.executeSelect("select count(*) c from rclvalues");	
>   	TestQueries.executeBulkInsertAnalyst(derby.getConnection(), 2000000);  // insert 2.000.000
rows
>         derby.executeDelete("delete from rclvalues where MOD(id, 3) = 0");          
  
>   	TestQueries.executeBulkInsertAnalyst(derby.getConnection(), 1000000);
>         derby.executeDelete("delete from rclvalues where MOD(id, 5) = 0");
>     	derby.executeSelect("select count(*) c from rclvalues");
> At the end of the operation, the table contains approximately the same number of rows.
But the size of the database  has grown  from
> 581 MB to 1.22 GB. From the description of item DERBY-132, I hoped that Derby does the
compression now ( version 10.1.X.X.).
> Did I overlook I still have to use  SYSCS_UTIL.SYSCS_COMPRESS_TABLE ?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message