Hi!
On May 22, 2009, at 11:25 AM, Sergei Golubchik wrote:
>> I did not notice much data copying when stepping through the code in
>> the debugger...
>
> Neither did I :)
Point your debugger at varchar and more importantly blobs. There is no
reason why you couldn't do a send file for most of the blob data (even
in cases where you had to do it in blocks because of the underlying
tables space).
Also, look at how Innodb works. Yes there is less copying with MyISAM/
HEAP but that is not what the majority of users I meet are using.
Cheers,
-Brian