[kmymoney4] [Bug 361876] Poor database performance after update

via KDE Bugzilla bugzilla_noreply at kde.org
Thu May 5 22:53:06 UTC 2016


--- Comment #8 from lp.allard.1 at gmail.com ---
I performed a quick performance benchmark on the database server:

Running the test with following options:
Number of threads: 8

Doing OLTP test.
Running mixed OLTP test
Doing read-only test
Using Special distribution (12 iterations,  1 pct of values are returned in 75
pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Threads started!
Time limit exceeded, exiting...
(last message repeated 7 times)

OLTP test statistics:
    queries performed:
        read:                            373534
        write:                           0
        other:                           53362
        total:                           426896
    transactions:                        26681  (444.61 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 373534 (6224.50 per sec.)
    other operations:                    53362  (889.21 per sec.)

Test execution summary:
    total time:                          60.0103s
    total number of events:              26681
    total time taken by event execution: 479.8500
    per-request statistics:
         min:                                  0.83ms
         avg:                                 17.98ms
         max:                                 60.14ms
         approx.  95 percentile:              29.97ms

Threads fairness:
    events (avg/stddev):           3335.1250/12.10
    execution time (avg/stddev):   59.9812/0.00

I am relying on the DB devs to tell me if this is considered acceptable for
usage with KMM..

You are receiving this mail because:
You are the assignee for the bug.

More information about the KMyMoney-devel mailing list