12 Sep
2005
12 Sep
'05
7:43 p.m.
And reading further, its memory waste may be huge. It says:
MEMORY tables use a fixed record length format.
So even if we change the longtext and text in the cache table to be varchar, it will still be treated as char, and A LOT OF memory would be wasted.
And you cannot change it to (var)char, since cache entries mostly exceed the 256 chars length. Goba