maria-discuss team mailing list archive

Thread
Date

A general question about performance of update command

To: "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
From: "Lehrbass, Robert" <RLehrbass@xxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 27 Sep 2021 19:29:49 +0000
Accept-language: en-US
Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=broadviewsoftware.com; dmarc=pass action=none header.from=broadviewsoftware.com; dkim=pass header.d=broadviewsoftware.com; arc=none
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=ObDCsZ+eW12Z3VofH7JTJN59LZknPDgjpRTuQWZz7kU=; b=FjFp2MOwG0AaU6ax/nJdsUy1j6hgqA+Xu4TcleYA+G5sJjgI+5LWPNdGPj54TCpDvneT2XqtcZTbIA+n1VYZ+bSIjn3Xj/jEFsKr3sj+Vf2ee3rplq+JBdEu8gz+qjlGB9YaWC1xMo/NkOnZxl4fC9u5hPgTgXrPtptJgyCym6mhjndSao8P7N3lHo33o6xG+q1FNc4clZ1XV83eKV4HEGSTJI8x49C1xjYFOvxo7HtjXjghwkcUh7mRiknCg/bQIJC/MR0ZX/bel4jBqQV/ZaqgBg6vDbb7fsYv394horJq8FfKNa+hmS6+fqVTNvIQnup5Dl8i2EUUUcSbWjQIDw==
Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=RYjueSq+335BsKeyYHvxflNllZCSOfnBXQhK/OgXrz0Tr2aUip6lvUfnidGgxJDbgtcZEjM73DebSgEowRpvexfRzUJiVKQqh1g6R5fj7anmadjiRP74Lq0w1sjp322KMRjuRkwRCtTKeetUhW4YL4tnbXsjJsgi6KTmWdCJV/Jy2dpLcmEjeTV9kdvYe4MyTZi2rBD0rThAaFeizZa6AEtSz/4GwvrpAO+12uXtRQxD3zPDfJlCn9WDIZa8ZNAjl+STVY9Ci4YRBPDdOiWLCNph0QODhC0a4P/nKOaIJ6pPQ1pJSzvA6cnVvfpmHpSEAYazcWrbUJ5hbyeP2cbwMA==
Authentication-results: lists.launchpad.net; dkim=none (message not signed) header.d=none;lists.launchpad.net; dmarc=none action=none header.from=broadviewsoftware.com;
Thread-index: Adez1I/oFU2m6abATlaGAqGLm/f8fA==
Thread-topic: A general question about performance of update command

Hi there,

I'm new to MariaDB and I'm running tests on the update command.  Server version 10.5.11.

I'm finding that updates to a table with engine=columnstore are far slower than to a table with default engine=innodb.  Obviously, there is no primary key in a table with engine=columnstore, whereas the innodb table does have a primary key.

In my tests, for engine=columnstore, 10000 rows took 1995 seconds to be updated, but for engine=innodb, 10000 rows took only 7 seconds to transfer.  The difference suggests columnstore takes about 285X longer than innodb.

Is this to be expected?  I don't need a lengthy answer, btw, just general guidance.
Thanks very much,
Rob