Create a myISAM table and put the table on a RAM DISK. It will support
everything that heap does and more, like ranges (< 4.1 only allows Hash
lookups).
CREATE TABLE (
..
) INDEX DIRECTORY = /dev/shm DATA DIRECTORY = /dev/shm
DVP
Dathan Vance Pattishall http://www.fri
At 1:09 PM -0700 11/29/04, <[EMAIL PROTECTED]> wrote:
I want to put a table in Ram (HEAP) with a field of at least 500
characters. I do I do this if Blob and text are not allowed?
The glib answer would be: you can't.
Two alternatives would be: (1) split your text field up into as many
char/varc
