db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: delete from table
Date Tue, 12 Jan 2010 05:06:09 GMT
Rami Ojares / PDF-Comics Oy wrote:
> 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.

The import procedures have a replace parameter which performs truncation 
of the table before the import. That will be much quicker than the delete.

Dan.



Mime
View raw message