Is there a Jira entry for this already? If not, it will be nice to enter one so we keep track of it.
Mamta On 5/10/05, Lance J. Andersen <[EMAIL PROTECTED]> wrote: > truncate table is a SQL extension supported by many database vendors now > as an optimization over delete table > > It is worth adding at somepoint to aid in porting apps from other backends > > Mike Matrigali wrote: > > > The following is sort of ugly, but will work with the current derby > > release, and the current trunk release. > > Look at the using the import system procedure with the replace option > > set to true and the source import being empty. I believe this will > > run faster than delete, even better would be if your application had > > a set of real rows to load when you want to truncate and use the table > > again. > > > > Here is a link to 10.0 documentation for the system procedure: > > http://incubator.apache.org/derby/manuals/reference/sqlj120.html#HDRIMPORTPROC > > > > > > I am not sure where truncate table is, I believe the issue is SQL > > standards. > > > > rahul merwah wrote: > > > >> Hi, > >> > >> > >> > >> I was wondering on the latest status of TRUNCATE TABLE SQL: command. > >> For the TODO list on the site I can tell that the code is basically > >> complete but needs to be exposed – I was just wondering what are the > >> details of the work items left and, if necessary, what I can help > >> with to get this finished. Would it help to expose this as a feature > >> request on JIRA so that comments can be documented there? Our simple > >> tests which require truncating a table with 32K rows is taking > >> painful minutes to complete (using DELETE FROM tablename; autocommit > >> off). I'm hoping even a naive TRUNCATE TABLE implementation will be > >> better than this by orders of magnitude! > >> > >> > >> > >> - Rahul Merwah > >> > >> Platform Architect > >> > >> Ecosystems > >> > >> > >> -- > >> No virus found in this outgoing message. > >> Checked by AVG Anti-Virus. > >> Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 5/9/2005 > >> > > >
