Re: Heap Help

[Steve Edberg]

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/varchar columns as necessary 9eg; text_part_1, text_part_2, 
...), and then split/rejoin those columns programmatically; or, (2) 
you might be able to losslessly compress or otherwise encode your 
text such that it will fit into a char(255) or smaller column.


Thanks
Donny Lairson
President
http://www.gunmuse.com/http://www.gunmuse.com
469 228 2183

--
+--- my people are the people of the dessert, ---+
| Steve Edberghttp://pgfsun.ucdavis.edu/ |
| UC Davis Genome Center[EMAIL PROTECTED] |
| Bioinformatics programming/database/sysadmin (530)754-9127 |
+ said t e lawrence, picking up his fork +

RE: Heap Help

[Dathan Vance Pattishall]

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