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 Radic’s picture

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

Gabriel Radic’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.