[MCOL-167] simple insertions 36X slower than MYISAM for COLUMNSTORE tables Created: 2016-06-22  Updated: 2022-02-25  Resolved: 2019-08-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: Justin Swanhart (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None


 Description   

My 'torture' test inserts 48 rows into a table.

Here is an example insert (note that warnings are expected):
MariaDB [test]> INSERT INTO fact VALUES ('1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345','1978-04-30 2:22:00.12345');
Query OK, 1 row affected, 26 warnings (0.30 sec)

Inserting the 48 rows in MyISAM takes .328s

The same exact test on columnstore takes 13 seconds

 Comments   
Comment by Todd Stoffel (Inactive) [ 2019-08-20 ]

Ticket is outdated. Closing.

Comment by Justin Swanhart (Inactive) [ 2019-08-20 ]

Did you test the current insertion speed. Closing a ticket because it is
old is not a valid reason for closing a ticket.

Comment by Justin Swanhart (Inactive) [ 2019-09-26 ]

Sigh. Typical mariadb.. lol.

Generated at Thu Feb 08 02:19:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.