Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.5.3
-
None
Description
MariaDB 10.5.5 single server.
create table t2 engine=columnstore... select * from t1
(regardless if t1 is innodb or columnstore)
is still slow.
100 rows / 80 columns in my tests take 8 minutes.
The same with t2 as innodb take a couple of seconds.
This is linear.
200 rows / 80 columns rows take 16 minutes.
199 row / 40 columns take 4 minutes.
Innodb on the same machine take 4 seconds.
A testcase with testdata is attached (p1.sql)