Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

ab synopse

🏠
Working from home
View GitHub Profile
View gist:e9d377ccecf81cdcd4f8836be109db6a
***** mORMot 2 integration using Delphi 10.4.2 Sidney for Win32 *****
d:\dev\lib2\test
Embarcadero Delphi for Win32 compiler version 34.0
Copyright (c) 1983,2021 Embarcadero Technologies, Inc.
367212 lines, 1.92 seconds, 5813292 bytes code, 303328 bytes data.
mORMot2 Regression Tests
--------------------------
View gist:ed997180e8563b7bdb230e3a4e0566f4
Running tests using Synopse mORMot framework 2.0.1, compiled with Delphi XE8 64 bit, against SQLite 3.36.0, on Windows 7 64bit SP1 (6.1.7601), at 2021-10-01 22:59:56.
Insertion speed (rows/second)
Direct Batch Trans Batch Trans
Sqlite file full 458 28616 123155 328558
Sqlite file off 2507 127749 127621 364245
Sqlite file off exc 50578 342032 127787 371982
Sqlite file off exc aes 50289 341227 118012 223553
Sqlite in memory 96394 371871 129394 380126
View gist:82d353ef3e07b2580022d0017d12c94d
Running tests using Synopse mORMot framework 2.0.1, compiled with Free Pascal 3.2 64 bit, against SQLite 3.36.0, on Windows 7 64bit SP1 (6.1.7601), at 2021-10-01 22:55:55.
Insertion speed (rows/second)
Direct Batch Trans Batch Trans
Sqlite file full 420 26493 115199 316225
Sqlite file off 2456 130843 122234 390426
Sqlite file off exc 48965 362963 123272 398295
Sqlite file off exc aes 28456 314801 121288 391527
View gist:3803d3c9b5ddc64720412e031b38c84a
Running tests using Synopse mORMot framework 2.0.1, compiled with Delphi XE8 32 bit, against SQLite 3.36.0, on Windows 7 64bit SP1 (6.1.7601), at 2021-10-01 22:51:36.
Insertion speed (rows/second)
Direct Batch Trans Batch Trans
Sqlite file full 412 24035 84798 262743
Sqlite file off 2450 114575 91237 308499
Sqlite file off exc 39312 281301 85116 317561
Sqlite file off exc aes 24192 246153 91617 252353
Sqlite in memory 72935 313666 91880 321947
@synopse
synopse / perftests.htm
Last active Sep 30, 2021
Performance tests using Synopse mORMot framework 1.18.6327
View perftests.htm
Running tests using Synopse mORMot framework 1.18.6327, compiled with Delphi 7 32 bit, against SQLite 3.36.0, at 2021-09-30 08:50:05.
Insertion speed
Direct Batch Trans Batch Trans
SQLite3 (file full) 64 3685 35459 104530
SQLite3 (file off) 620 33711 56636 220555
SQLite3 (file off exc) 2892 77737 55350 219394
SQLite3 (mem) 50741 206168 61736 306128
TObjectList (static) 147349 492513 150902 512295
@synopse
synopse / gist:0e7275684a2e2bbd2206940c3827055c
Created Aug 17, 2021
mORMot 2 regression tests on Oracle Cloud Ampere CPU
View gist:0e7275684a2e2bbd2206940c3827055c
ubuntu@lxde:/tmp$ ./mormot2tests
mORMot2 Regression Tests
--------------------------
1. Core units
1.1. Core base:
- RecordCopy: 743 assertions passed 35us
@synopse
synopse / gist:487394d93de900b00f2200017088452d
Created Aug 12, 2021
mORMot 2 tests on Delphi 10.3 Win64
View gist:487394d93de900b00f2200017088452d
mORMot2 Regression Tests
--------------------------
1. Core units
1.1. Core base:
- RecordCopy: 743 assertions passed 1.02ms
- TRawUtf8List: 190,172 assertions passed 66.71ms
@synopse
synopse / gist:256190aa6d8e14f41a9d45ed99f07da6
Created Aug 6, 2021
mORMot 2 Tests on Oracle Cloud Ampere AARCH64 Server
View gist:256190aa6d8e14f41a9d45ed99f07da6
mORMot2 Regression Tests
--------------------------
1. Core units
1.1. Core base:
- RecordCopy: 743 assertions passed 209us
- TRawUtf8List: 190,172 assertions passed 79.06ms
View gist:60fe59d4072bd3e152f51db5d6294c39
mORMot2 Regression Tests
--------------------------
1. Core units
1.1. Core base:
- RecordCopy: 743 assertions passed 523us
- TRawUtf8List: 190,172 assertions passed 110.96ms
- TDynArray: 1,091,804 assertions passed 203.23ms
@synopse
synopse / gist:83250a890fd23b0f8b748db227b3cc6d
Created Jul 9, 2021
mORMot 2 regression tests on another much smaller ATOM computer (the synopse server at dedibox)
View gist:83250a890fd23b0f8b748db227b3cc6d
synopse@sd-73991:~/temp$ ./mormot2tests
mORMot2 Regression Tests
--------------------------
1. Core units
1.1. Core base:
- RecordCopy: 743 assertions passed 77us