[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. |