db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rami Ojares / PDF-Comics Oy <r...@absinth.fi>
Subject delete from table
Date Mon, 11 Jan 2010 21:47:38 GMT

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?

- rami

View raw message