subject:"Heap table limitations"

Re: Heap table limitations

2004-05-20 Thread Sasha Pachev

Daniel Cummings wrote: We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. You think it would, or it already has in your testing? Heap vs. MyISAM

RE: Heap table limitations

2004-05-20 Thread emierzwa

your table from accidentally eating all of you're available memory. Ed -Original Message- From: Daniel Cummings [mailto:[EMAIL PROTECTED] Subject: Heap table limitations We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from I

Heap table limitations

2004-05-20 Thread Daniel Cummings

We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost. Does making a heap file this large make any sense? Are there size limitations to heap