At 12:20 PM 11/21/2007, you wrote:
mos wrote:
Jerry,
Does TRUNCATE work on a merge table?
Apparently not.
I tried:
"truncate table mymergetable" and got:
Error Code : 1
Can't create/write to file '.\dbname\mymergetable.MRG' (Errcode: 17)
I even tried a Flush Tables before the truncate and tha
the merge definition changes, I have to remember to remember to
update the deletes as well.
Mike
- Original Message
From: Chris <[EMAIL PROTECTED]>
To: mos <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 20, 2007 11:13:58 PM
Subject: Re: Why is
Jerry,
Does TRUNCATE work on a merge table?
Apparently not.
I tried:
"truncate table mymergetable" and got:
Error Code : 1
Can't create/write to file '.\dbname\mymergetable.MRG' (Errcode: 17)
I even tried a Flush Tables before the truncate and that didn't help.
So it looks like I'll have to
FROM'
without a WHERE clause to a DELETE FROM on all underlying MyISAM tables.
- Original Message
From: Chris <[EMAIL PROTECTED]>
To: mos <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 20, 2007 11:13:58 PM
Subject: Re: Why is Delete slow on a Merge Table?
mos wrote:
I have a merge table that is a union of 20 1 million row tables. Select
rows from it is quite fast. However if I want to delete all the rows as in:
delete from MyMergeTable;
it takes just over 3 minutes. I could execute 20 separate delete
statements for each of the 20 tables and it
Does TRUNCATE work on a merge table? I honestly don't know, but it should be
faster than a DELETE for removing all of the records.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.c
