TestSQL3.exe output

   Synopse mORMot Framework Automated tests
  ------------------------------------------


1. Synopse libraries

 1.1. Low level common:
  - System copy record: 83 assertions passed  64us
  - TRawUTF8List: 130,009 assertions passed  118.63ms
  - TDynArray: 1,082,723 assertions passed  376.78ms
  - TDynArrayHashed: 1,200,629 assertions passed  216.86ms
  - TObjectListHashed: 999,766 assertions passed  551.73ms
  - TObjectDynArrayWrapper: 167,501 assertions passed  112.48ms
  - TObjArray: 2,016 assertions passed  3.77ms
  - Fast string compare: 24 assertions passed  46us
  - IdemPropName: 197 assertions passed  167us
  - Url encoding: 150 assertions passed  1.16ms
  - GUID: 9,005 assertions passed  12.38ms
  - IsMatch: 599 assertions passed  854us
  - Soundex: 35 assertions passed  25us
  - Numerical conversions: 1,116,258 assertions passed  1.23s
  - crc32c: 20,020 assertions passed  71.54ms
      pas 19.48ms 306.2 MB/s fast 3.89ms 1.4 GB/s
  - Curr 64: 20,053 assertions passed  2.66ms
  - CamelCase: 11 assertions passed  33us
  - Bits: 4,774 assertions passed  119us
  - Ini files: 7,004 assertions passed  37.15ms
  - UTF8: 86,131 assertions passed  908.78ms
  - Iso 8601 date and time: 48,017 assertions passed  14.38ms
  - Time zones: 407 assertions passed  10.73ms
  - Url decoding: 1,100 assertions passed  287us
  - Mime types: 27 assertions passed  67us
  - TSynTable: 875 assertions passed  6.35ms
  - TSynCache: 404 assertions passed  149us
  - TSynFilter: 804 assertions passed  2.69ms
  - TSynValidate: 677 assertions passed  1.01ms
  - TSynLogFile: 42 assertions passed  1.07ms
  - TSynUniqueIdentifier: 1,300,002 assertions passed  879.98ms
  Total failed: 0 / 6,199,343  - Low level common PASSED  4.56s

 1.2. Low level types:
  - RTTI: 410 assertions passed  371us
  - Url encoding: 200 assertions passed  1.43ms
  - Encode decode JSON: 282,731 assertions passed  5.44s
  - Variants: 48 assertions passed  47us
  - Mustache renderer: 144 assertions passed  1.15s
  - TDocVariant: no assertion  23us
  - BSON: no assertion  12us
  - TSynTableStatement: 206 assertions passed  185us
  - TSynMonitorUsage: 1,202 assertions passed  190us
  Total failed: 0 / 284,941  - Low level types PASSED  6.60s

 1.3. Cryptographic routines:
  - Adler32: 1 assertion passed  24us
  - MD5: 86 assertions passed  295us
  - SHA1: 10 assertions passed  6.07ms
  - SHA256: 8 assertions passed  10.64ms
!  - AES256: 1 / 12,178 FAILED  560.15ms
  - RC4: 1 assertion passed  25us
  - Base64: 11,994 assertions passed  123.11ms
  - CompressShaAes: 1,683 assertions passed  4.86ms
  Total failed: 1 / 25,961  - Cryptographic routines FAILED  705.39ms

 1.4. Compression:
  - In memory compression: 12 assertions passed  472.24ms
  - GZIP format: 19 assertions passed  930.85ms
  - ZIP format: 64 assertions passed  3.40s
  - SynLZO: 3,006 assertions passed  106.52ms
  - SynLZ: 32,221 assertions passed  668.51ms
  Total failed: 0 / 35,322  - Compression PASSED  5.58s


2. mORMot

 2.1. File based:
  - Database direct access: 20,251 assertions passed  215.33ms
  - Virtual table direct access: 12 assertions passed  6.21ms
  - TSQLTableJSON: 144,070 assertions passed  168.48ms
  - TSQLRestClientDB: 608,193 assertions passed  7.74s
  - TRecordVersion: 20,060 assertions passed  180.71ms
  Total failed: 0 / 792,586  - File based PASSED  8.31s

 2.2. File based memory map:
  - Database direct access: 20,246 assertions passed  283.92ms
  - Virtual table direct access: 12 assertions passed  18.60ms
  - TSQLTableJSON: 144,070 assertions passed  250.51ms
  - TSQLRestClientDB: 608,192 assertions passed  7.86s
  - TRecordVersion: 20,060 assertions passed  182.98ms
  Total failed: 0 / 792,580  - File based memory map PASSED  8.59s

 2.3. File based WAL:
  - Database direct access: 20,251 assertions passed  369.51ms
  - Virtual table direct access: 12 assertions passed  7.67ms
  - TSQLTableJSON: 144,070 assertions passed  237.17ms
  - TSQLRestClientDB: 608,193 assertions passed  7.43s
  - TRecordVersion: 20,060 assertions passed  182.91ms
  Total failed: 0 / 792,586  - File based WAL PASSED  8.23s

 2.4. Memory based:
  - Database direct access: 20,246 assertions passed  253.13ms
  - Virtual table direct access: 12 assertions passed  5.21ms
  - TSQLTableJSON: 144,070 assertions passed  273.68ms
  - TSQLRestClientDB: 676,500 assertions passed  7.30s
  - TRecordVersion: 20,060 assertions passed  184.01ms
  - RTree: 140,000 assertions passed  1.45s
  Total failed: 0 / 1,000,888  - Memory based PASSED  9.47s

 2.5. Basic classes:
!  - TSQLRecord: 1 / 88 FAILED  744us
  - TSQLRecordSigned: 200 assertions passed  4.88ms
  - TSQLModel: 16 assertions passed  78us
  - TSQLRestServerFullMemory: 982,483 assertions passed  1.79s
  Total failed: 1 / 982,787  - Basic classes FAILED  1.80s

 2.6. Client server access:
  - TSQLHttpServer: 2 assertions passed  24.60ms
     using HTTP API 2.0
  - TSQLHttpClient: 3 assertions passed  25.79ms
     using TSQLHttpClientWinHTTP
  - HTTP client keep alive: 3,087 assertions passed  469.81ms
     4818 B, first 4.60ms, done 429.15ms i.e. 2330/s, aver. 429us, 10.8 MB/s
  - HTTP client multi connect: 3,087 assertions passed  442.44ms
     4818 B, first 523us, done 426.60ms i.e. 2344/s, aver. 426us, 10.9 MB/s
  - HTTP client encrypted: 3,087 assertions passed  584.03ms
     4818 B, first 784us, done 565.99ms i.e. 1766/s, aver. 565us, 8.2 MB/s
  - Named pipe access: 3,089 assertions passed  750.29ms
     4818 B, first 260.25ms, done 277.57ms i.e. 3602/s, aver. 277us, 16.8 MB/s
  - Local window messages: 3,088 assertions passed  99.97ms
     4818 B, first 164us, done 93.50ms i.e. 10694/s, aver. 93us, 50 MB/s
  - Direct in process access: 3,056 assertions passed  60.51ms
     4818 B, first 60us, done 51.16ms i.e. 19544/s, aver. 51us, 91.3 MB/s
  - HTTP several DB servers: 9,604 assertions passed  1.61s
     4818 B, first 584us, done 443.62ms i.e. 2254/s, aver. 443us, 10.5 MB/s
     4818 B, first 561us, done 439.54ms i.e. 2275/s, aver. 439us, 10.6 MB/s
     4818 B, first 641us, done 523.54ms i.e. 1910/s, aver. 523us, 8.9 MB/s
  Total failed: 0 / 28,103  - Client server access PASSED  4.07s

 2.7. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  87us
  - Service initialization: 267 assertions passed  4.64ms
  - Direct call: 537,186 assertions passed  49.77ms
  - Server side: 537,206 assertions passed  52.46ms
  - Client side REST: 716,274 assertions passed  1.56s
  - Client side REST as JSON object: 716,268 assertions passed  1.61s
  - Client side REST sessions stats: 716,268 assertions passed  1.56s
  - Client side REST locked: 716,272 assertions passed  1.54s
  - Client side REST main thread: 716,272 assertions passed  3.51s
  - Client side REST background thread: 716,272 assertions passed  3.77s
  - Client side REST weak authentication: 716,268 assertions passed  1.26s
  - Client side REST basic authentication: 716,268 assertions passed  1.73s
  - Client side REST custom record layout: 716,268 assertions passed  1.55s
  - Client side REST service log to DB: 716,268 assertions passed  3.20s
  - Client side JSONRPC: 716,268 assertions passed  1.67s
  - Test over HTTP: 7,661 assertions passed  753.23ms
  - Security: 135 assertions passed  3.13ms
  - Mocks and stubs: 30,030 assertions passed  98.68ms
  Total failed: 0 / 8,991,507  - Service oriented architecture PASSED  23.97s

 2.8. Bidirectional remote connection:
  - Websockets JSON protocol: 60 assertions passed  106us
  - Websockets binary protocol: 240 assertions passed  398us
  - Run http server: 2 assertions passed  718us
  - SOA callback on server side: 4,578 assertions passed  3.62ms
  - SOA callback via JSON websockets: 4,581 assertions passed  177.78ms
  - SOA callback via binary websockets: 4,581 assertions passed  177.96ms
  - TRecordVersion: 20,068 assertions passed  197.64ms
  Total failed: 0 / 34,110  - Bidirectional remote connection PASSED  558.43ms

 2.9. External database:
  - TQuery: 2,003 assertions passed  9.20ms
  - SynDBRemote: 30,095 assertions passed  903.58ms
  - DB properties persistence: 7 assertions passed  5.11ms
  - External records: 2 assertions passed  379us
  - Auto adapt SQL: 942 assertions passed  123.63ms
  - Crypted database: 253,275 assertions passed  311.55ms
  - External via REST: 170,354 assertions passed  1.78s
  - External via virtual table: 170,354 assertions passed  2.96s
  - External via REST with change tracking: 180,454 assertions passed  4.06s
  - JET database: 7,007 assertions passed  1.18s
  Total failed: 0 / 814,493  - External database PASSED  11.35s

 2.10. Multi thread process:
  - Create thread pool: 1 assertion passed  2.56ms
  - TSQLRestServerDB: 4,822 assertions passed  150.24ms
     1=17177/s  2=17881/s  5=16663/s  10=18179/s  30=17696/s  50=16781/s
  - TSQLRestClientDB: 4,822 assertions passed  207.41ms
     1=15887/s  2=16596/s  5=17053/s  10=14924/s  30=9010/s  50=7748/s
  - TSQLRestClientURINamedPipe: 2,412 assertions passed  1.51s
     1=1177/s  2=1160/s  5=648/s
  - TSQLRestClientURIMessage: 3,222 assertions passed  209.27ms
     1=8888/s  2=8598/s  5=8743/s  10=6710/s
  - Windows API: 4,822 assertions passed  539.32ms
     1=2793/s  2=4839/s  5=5031/s  10=5991/s  30=5723/s  50=4995/s
!  - Socket API: 97 / 2,439 FAILED  20.33s
     1
!  - Websockets: 79 / 3,405 FAILED  920.39s
     1=5265/s  2=6085/s  5=5850/s  10=6135/s  30=0/s  50=0/s
  - Locked: 4,822 assertions passed  198.70ms
     1=14672/s  2=15487/s  5=15962/s  10=14432/s  30=11381/s  50=8698/s
  - Unlocked: 4,822 assertions passed  158.95ms
     1=14046/s  2=14761/s  5=17494/s  10=17659/s  30=19281/s  50=15723/s
  - Main thread: 4,822 assertions passed  156.60ms
     1=13489/s  2=17509/s  5=17674/s  10=17335/s  30=18388/s  50=16455/s
  - Background thread: 4,822 assertions passed  167.52ms
     1=12523/s  2=17224/s  5=15257/s  10=15661/s  30=17795/s  50=15081/s
  Total failed: 176 / 45,233  - Multi thread process FAILED  944.03s

 2.11. DDD shared units:
  - User model: 3,276 assertions passed  769us
  - Authentication model: 20,006 assertions passed  243.47ms
!  - Email validation process: 3 / 55 FAILED  26.77ms
!  - User CQRS repository: 7,002 / 57,106 FAILED  1.10s
  Total failed: 7,005 / 80,443  - DDD shared units FAILED  1.37s

 2.12. DDD multi thread:
  - Delete old database: 1 assertion passed  101us
  - Start server: 1 assertion passed  96.29ms
  - Single client test: 1,002 assertions passed  438.73ms
  - Multi threaded clients test: 21 assertions passed  1.64s
  Total failed: 0 / 1,025  - DDD multi thread PASSED  2.18s


Using mORMot 1.18.2394 FTS3
Running on Windows 10 64bit (10.0.10586) with code page 1252
TSQLite3LibraryStatic 3.10.2 with internal MM
Generated with: Free Pascal 3.1.1 compiler

Time elapsed for all tests: 1041.49s
Tests performed at 14-02-2016 20:47:35

Total assertions failed for all test suits:  7,183 / 20,901,908
! Some tests FAILED: please correct the code.