Rami Ojares / PDF-Comics Oy <[email protected]> writes: > Hi, > > It seems that deleting a table takes a VERY long time. > I am importing data into derby. > And as I work with my import script I have to do the import MANY times. > So in the beginning of my import I first delete everything from the > tables I have previously imported into. > > It seems that deleting takes at least as long as doing the import. > > So my question is twofold. > 1) Why is that so? > 2) Are there any plans to support a truncate or similar command (like > in mysql) where the delete just wipes everything away from the table > without making all kinds of checks?
There is an undocumented TRUNCATE command available in debug builds of Derby, but not in production builds. There is also a request for TRUNCATE in the issue tracker, see https://issues.apache.org/jira/browse/DERBY-268. If this is a feature you would like to see in Derby, you should vote for it to give it more visibility. Or even better, volunteer to complete the implementation! :) -- Knut Anders
