[jira] [Commented] (OAK-8926) add RDBBlobStore performance test

["Julian Reschke (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OAK-8926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051075#comment-17051075 ] 

Julian Reschke commented on OAK-8926:
-------------------------------------

Example output (in unit test log):

{noformat}
inserted 2126 blocks of size 1500 into RDB-DB2 (0 errors) in 2000ms (1063 blocks/s)
inserted 11348 blocks of size 1500 into RDB-H2(file) (0 errors) in 2000ms (5674 blocks/s)
inserted 4396 blocks of size 1500 into RDB-Derby(embedded) (0 errors) in 2000ms (2198 blocks/s)
inserted 323 blocks of size 1500 into RDB-MSSql (0 errors) in 2000ms (161 blocks/s)
inserted 153 blocks of size 1500 into RDB-MySQL (0 errors) in 2000ms (76 blocks/s)
inserted 1729 blocks of size 1500 into RDB-Oracle (0 errors) in 2000ms (864 blocks/s)
inserted 1954 blocks of size 1500 into RDB-Postgres (0 errors) in 2000ms (977 blocks/s)
{noformat}

So SQL Server and MySQL stand out. This might be because they do not handle "large" character primary keys well.

> add RDBBlobStore performance test
> ---------------------------------
>
>                 Key: OAK-8926
>                 URL: https://issues.apache.org/jira/browse/OAK-8926
>             Project: Jackrabbit Oak
>          Issue Type: Technical task
>          Components: rdbmk
>            Reporter: Julian Reschke
>            Assignee: Julian Reschke
>            Priority: Minor
>              Labels: candidate_oak_1_22
>             Fix For: 1.26.0
>
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)