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
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 TABLE NAME (
..
) INDEX DIRECTORY = /dev/shm DATA DIRECTORY = /dev/shm
DVP
Dathan Vance Pattishall