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 http://www.friendster.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 29, 2004 12:10 PM To: Mysql Subject: Heap Help 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? Thanks Donny Lairson President http://www.gunmuse.com <http://www.gunmuse.com/> 469 228 2183