[MDEV-14316] Revisit benchmark Created: 2017-11-07  Updated: 2023-10-07  Resolved: 2023-10-07

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Charles Evans Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: optimizer


 Description   

In https://www.ncbi.nlm.nih.gov/pubmed/25560631 the authors found dismal performance of MariaDB relative to PostgreSQL while extracting overlapping regions. (GitLab cites this as their reason for not fully supporting MariaDB.) How does version 10 fare on the same test?



 Comments   
Comment by Sergei Golubchik [ 2017-11-08 ]

I don't know. The article mentions in the abstract a "novel region-mapping (RegMap) SQL-based algorithm to perform genomic operations" and that "PostgreSQL extracts overlapping regions much faster than MySQL".

I don't have access to the article itself, so I cannot know what this novel algorithm is, what version of MariaDB was tested, and whether MariaDB was tested at all, as the abstract only mentions MySQL.

Comment by Sergei Golubchik [ 2017-11-08 ]

As far as GitLab is concerned, I didn't find where they mention this article. They generally recommend PostgreSQL over "MySQL/MariaDB" (for example here) because, apparently, GitLab is developed with the PostgreSQL in mind, all features and queries are optimized for PostgreSQL and don't work well elsewhere.

Generated at Thu Feb 08 08:12:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.