In terms of real-world applications, I'm not sure what conclusions can be drawn from these results.

V17 performs much better on a brand-new empty database, and V10 performs better after several test runs, even after the cache is flushed and the engine is restarted.

The V17 performance is consistent over all tests.

The "read_duration" measurement is too small to be useful.

10.0.1.4310 write_duration = 40586 read_duration = 528
17.0.9.4882 write_duration = 15682 read_duration = 83

10.0.1.4310 write_duration = 13027 read_duration = 144
17.0.9.4882 write_duration = 15130 read_duration = 75

10.0.1.4310 write_duration = 8269 read_duration = 47
17.0.9.4882 write_duration = 14868 read_duration = 61

ROLLBACK;
CHECKPOINT;
CALL sa_flush_cache();

10.0.1.4310 write_duration = 7710 read_duration = 49
17.0.9.4882 write_duration = 14493 read_duration = 62

Stop and restart database.

10.0.1.4310 write_duration = 8659 read_duration = 727
17.0.9.4882 write_duration = 14481 read_duration = 62

Delete and dbinit database.

10.0.1.4310 write_duration = 47181 read_duration = 2046
17.0.9.4882 write_duration = 16390 read_duration = 123

begin
declare i int;
declare pos1 int;
declare pos2 int;
declare pos3 int;
declare pos4 int;
declare trans1 int;
declare trans2 int;
declare mychar varchar(4);
declare write_duration int;
declare read_duration int;
declare starttime datetime;
declare endtime datetime;

if exists (select 1 from systable where table_name = 'mytest') then
drop table mytest;
end if;

create table mytest (sn int, testname varchar (5));

set starttime = now();
set i = 0;

while (i<456976) loop
set pos1 = (i/17576);
set trans1 = mod(i, 17576);
set pos2 = (trans1/676);
set trans2 = mod(trans1,676);
set pos3 = (trans2/26);
set pos4 = mod(trans2,26);
set mychar = char(pos1+65) + char(pos2+65) + char(pos3+65) + char(pos4+65);
insert into mytest (sn, testname) values (i, mychar);
set i = i+1;
end loop;

set endtime = now();
set write_duration = datediff (millisecond, starttime, endtime);
set starttime = now();
select testname into mychar from mytest where testname = 'SAKO';
set endtime = now();
set read_duration = datediff (millisecond, starttime, endtime);

MESSAGE STRING ( @@VERSION, ' write_duration = ', write_duration, ' read_duration = ', read_duration ) TO CONSOLE;

select write_duration, read_duration ;
end;