Re: Strange problem: Increasing Memory / HEAP Table

2006-03-13 Thread sheeri kritzer
What does SHOW CREATE TABLE give you? -Sheeri On 3/11/06, Holger Sunke [EMAIL PROTECTED] wrote: Hallo, is there a way of maintaining Memory tables or rebuilding indexes? I have a big memory table with about 300k rows, 12 Attributes, 7 BTREE-Indexes and a PRIMARY KEY (Hash index). Now

Strange problem: Increasing Memory / HEAP Table

2006-03-11 Thread Holger Sunke
Hallo, is there a way of maintaining Memory tables or rebuilding indexes? I have a big memory table with about 300k rows, 12 Attributes, 7 BTREE-Indexes and a PRIMARY KEY (Hash index). Now i'm doing many many Updates (and a little number of inserts) on this table that also do effect indexed