You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2009/04/17 22:12:15 UTC

[Db-derby Wiki] Update of "TenFiveOneBuddyTesting" by KatheyMarsden

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by KatheyMarsden:
http://wiki.apache.org/db-derby/TenFiveOneBuddyTesting

------------------------------------------------------------------------------
  || OFFSET/FETCH FIRST || [https://issues.apache.org/jira/browse/DERBY-4079 DERBY-4079] || Mamta || yes || ||
  || standard SQL "SET" keyword in ALTER COLUMN || [https://issues.apache.org/jira/browse/DERBY-4013 DERBY-4013] || Mamta || || ||
  || In-memory back end || [https://issues.apache.org/jira/browse/DERBY-646 DERBY-646] || Rick || yes || 1) Verified that in-memory db leaves no disk footprint if you set the derby.stream properties appropriately 2) Verified that VFMemoryStorageFactory.purgeDatabase( ) removes an in-memory database (primer updated). 3) Verified that you can backup an in-memory db using SYSCS_UTIL.SYSCS_BACKUP_DATABASE, remove the database from memory, then recreate it using the createFrom URL attribute 4) I increased the heap size to 512m and then began filling up a table by doubling its size with insert...select statements. I did not notice any performance difference across various page cache sizes: 2000, 1000, 500, 250, 125, and 60. ||
- || Update Statistics Stored Procedure|| [https://issues.apache.org/jira/browse/DERBY-269 DERBY-269]  || Kathey ||yes || ||
+ || Update Statistics Stored Procedure|| [https://issues.apache.org/jira/browse/DERBY-269 DERBY-269]  || Kathey ||yes ||Completed. Filed and fixed [https://issues.apache.org/jira/browse/DERBY-4116 DERBY-4116]. Kim filed and fixed [https://issues.apache.org/jira/browse/DERBY-4121 DERBY-4121] for doc fixes.  Filed [https://issues.apache.org/jira/browse/DERBY-4115 DERBY-4115] improvement request to allow drop statistics||