db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: TRUNCATE TABLE availability
Date Mon, 09 May 2005 23:29:08 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=windows-1250"
 http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Have you tried DROP TABLE followed by a CREATE TABLE? That should work
pretty good and is a good TRUNCATE TABLE implementation!<span
 class="moz-smiley-s1"><span> :-) </span></span><br>
<br>
Satheesh<br>
<br>
rahul merwah wrote:<br>
<blockquote
 cite="mid20050509172720.EESD1720.mm-ismta4.bizmailsrvcs.net@eco1"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta name="Generator" content="Microsoft Word 11 (filtered medium)">
  <style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
  </style>
  <div class="Section1">
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;">Hi,<o:p></o:p></span></font></p>
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;">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!<o:p></o:p></span></font></p>
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;"><o:p> </o:p></span></font></p>
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;">- Rahul Merwah<o:p></o:p></span></font></p>
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;">Platform Architect<o:p></o:p></span></font></p>
  <p class="MsoNormal"><font face="Arial" size="2"><span
 style="font-size: 10pt; font-family: Arial;">Ecosystems<o:p></o:p></span></font></p>
  </div>
  <br>
  <p><font size="2">--<br>
No virus found in this outgoing message.<br>
Checked by AVG Anti-Virus.<br>
Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 5/9/2005<br>
  </font> </p>
</blockquote>
</body>
</html>


Mime
View raw message