Has anyone tried to take advantage of the MEMORY/HEAP engine in MySQL ?

I thought about using it to avoir cache queries, combined to some hashing.

Worth trying something ?



Gabriel R.’s picture

Did you try it?
I'm about to give it a try myself.

Gabriel R.’s picture

That was a quick test...

> An error occurred when trying to change the table type to 'MEMORY'.
> MySQL said: The used table type doesn't support BLOB/TEXT columns

Too bad.

fxarte’s picture

No errors when applied to node_acess. My site heavily uses access control, so it made sense to try it there.