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).

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