NAME

Bencher::Scenario::PerinciTxManager::ViaPeriAS - Benchmark using transaction via Perinci::Access::Schemeless

VERSION

This document describes version 0.001 of Bencher::Scenario::PerinciTxManager::ViaPeriAS (from Perl distribution Bencher-Scenarios-PerinciTxManager), released on 2018-11-11.

SYNOPSIS

To run benchmark with default option:

 % bencher -m PerinciTxManager::ViaPeriAS

For more options (dump scenario, list/include/exclude/add participants, list/include/exclude/add datasets, etc), see bencher or run bencher --help.

DESCRIPTION

Packaging a benchmark script as a Bencher scenario makes it convenient to include/exclude/add participants/datasets (either via CLI or Perl code), send the result to a central repository, among others . See Bencher and bencher (CLI) for more details.

BENCHMARKED MODULES

Version numbers shown below are the versions used when running the sample benchmark.

File::Temp 0.2304

Perinci::Access::Schemeless 0.88

Setup::File 0.23

UUID::Random 0.04

BENCHMARK PARTICIPANTS

• perias (perl_code)

  Code template:

   use 5.010;
   use Perinci::Access::Schemeless;
   use Perinci::Tx::Manager;
   use UUID::Random;
   
   if (!$main::tempdir) {
       require File::Temp;
       $main::tempdir = File::Temp::tempdir();
       mkdir "$main::tempdir/tm"    or die "Can't mkdir $main::tempdir/tm: $!";
       mkdir "$main::tempdir/setup" or die "Can't mkdir $main::tempdir/setup: $!";
   }
   
   state $pa = Perinci::Access::Schemeless->new(
       wrap => 0,
       use_tx => 1,
       custom_tx_manager => sub {
           my $pa = shift;
           Perinci::Tx::Manager->new(pa => $pa, data_dir=>"$main::tempdir/tm");
       },
   );
   
   for my $i (1..<num_txs>) {
       my $txid = UUID::Random::generate(); $txid =~ s/-.+//;
       my $res;
       $res = $pa->request(begin_tx => "/", {tx_id=>$txid, summary=>""});
       $res->[0] == 200 or die "Can't begin_tx: $res->[0] - $res->[1]";
       for my $j (1..<num_actions_per_tx>) {
           $res = $pa->request(call => "/Setup/File/setup_dir", {args=>{path=>"$main::tempdir/setup/$j", should_exist=>1}, tx_id=>$txid});
           $res->[0] =~ /\A(200|304)\z/ or die "Can't call #$j: $res->[0] - $res->[1]";
       } # action
       $res = $pa->request(commit_tx => "/", {tx_id=>$txid});
       $res->[0] == 200 or die "Can't commit_tx: $res->[0] - $res->[1]";
   } # tx
   

BENCHMARK DATASETS

• tx=1 actions=1

• tx=1 actions=10

• tx=1 actions=100

SAMPLE BENCHMARK RESULTS

Run on: perl: v5.26.1, CPU: Intel(R) Core(TM) M-5Y71 CPU @ 1.20GHz (2 cores), OS: GNU/Linux LinuxMint version 18.3, OS kernel: Linux version 4.10.0-38-generic.

Benchmark with default options (bencher -m PerinciTxManager::ViaPeriAS):

 #table1#
 +------------------+-----------+------+------------+---------+---------+
 | dataset          | rate (/s) | time | vs_slowest |  errors | samples |
 +------------------+-----------+------+------------+---------+---------+
 | tx=1 actions=100 |      0.47 | 2.1  |        1   | 0.011   |      20 |
 | tx=1 actions=10  |      4.4  | 0.23 |        9.4 | 0.00088 |      20 |
 | tx=1 actions=1   |     30    | 0.04 |       60   | 0.00043 |      21 |
 +------------------+-----------+------+------------+---------+---------+

To display as an interactive HTML table on a browser, you can add option --format html+datatables.

BENCHMARK NOTES

actions=100 is (2/s) indeed much slower than actions=10 (18/s, 9.7x) and actions=1 (90/s, 50x).

PROFILE NOTES

For "tx=1 actions=100" (100 actions in a single transaction, ~1.2s), 1314 SQL execute() (~0.6s, 0.46ms per execute()) and 1413 do() are performed. The bulk of the exclusive time is inside execute() (~0.6s, >50%). That means ~13 SQL query per function action. Or about 6ms SQL execute() overhead per function action.

This makes Perinci::Tx::Manager generally quite slow when we involve a large number of function actions. To speed things up, we need: 1) a much faster database; 2) group multiple actions inside a single function action (which is not always easy to do).

HOMEPAGE

Please visit the project's homepage at https://metacpan.org/release/Bencher-Scenarios-PerinciTxManager.

SOURCE

Source repository is at https://github.com/perlancar/perl-Bencher-Scenarios-PerinciTxManager.

BUGS

Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=Bencher-Scenarios-PerinciTxManager

When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.

AUTHOR

perlancar <perlancar@cpan.org>

COPYRIGHT AND LICENSE

This software is copyright (c) 2018 by perlancar@cpan.org.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

cpanm Bencher::Scenarios::PerinciTxManager

perl -MCPAN -e shell
install Bencher::Scenarios::PerinciTxManager