#1 2016-03-04 14:22:40

miab3
Member
From: Poland
Registered: 2014-10-01
Posts: 185

TestSQL3 - CodeTyphon 5.70 - mORMot 1.18.2439

@ab,

CodeTyphon 5.70-Win32; mORMot 1.18.2439; Windows 7-64

Compile and run:
- Project01,
- Project02,
- Project04Server - Project04Client.


TestSQL3 compile and:

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


1. Synopse libraries

 1.1. Low level common:
  - System copy record: 83 assertions passed  84us
  - TRawUTF8List: 130,009 assertions passed  40.28ms
  - TDynArray: 1,082,723 assertions passed  248.63ms
  - TDynArrayHashed: 1,200,629 assertions passed  111.80ms
  - TObjectListHashed: 999,768 assertions passed  277.11ms
  - TObjectDynArrayWrapper: 167,501 assertions passed  26.68ms
  - TObjArray: 2,016 assertions passed  2.24ms
  - Fast string compare: 24 assertions passed  169us
  - IdemPropName: 197 assertions passed  115us
  - Url encoding: 150 assertions passed  830us
  - GUID: 9,005 assertions passed  7.97ms
  - IsMatch: 599 assertions passed  275us
  - Soundex: 35 assertions passed  93us
  - Numerical conversions: 1,112,310 assertions passed  399.29ms
  - crc32c: 30,030 assertions passed  56.14ms
      pas 17.30ms 344.7 MB/s fast 2.80ms 2 GB/s sse42 1.22ms 4.7 GB/s
  - Curr 64: 20,053 assertions passed  1.78ms
  - CamelCase: 11 assertions passed  64us
  - Bits: 4,774 assertions passed  384us
  - Ini files: 7,004 assertions passed  17.18ms
  - UTF8: 99,130 assertions passed  539.17ms
  - Iso 8601 date and time: 48,017 assertions passed  6.82ms
  - Time zones: 407 assertions passed  4.72ms
  - Url decoding: 1,100 assertions passed  413us
  - Mime types: 30 assertions passed  431us
  - TSynTable: 875 assertions passed  4.49ms
  - TSynCache: 404 assertions passed  198us
  - TSynFilter: 804 assertions passed  1.86ms
  - TSynValidate: 677 assertions passed  893us
  - TSynLogFile: 42 assertions passed  553us
  - TSynUniqueIdentifier: 1,300,002 assertions passed  512.43ms
  Total failed: 0 / 6,218,409  - Low level common PASSED  2.27s

 1.2. Low level types:
  - RTTI: 410 assertions passed  451us
  - Url encoding: 200 assertions passed  579us
  - Encode decode JSON: 283,349 assertions passed  196.08ms
  - Variants: 48 assertions passed  142us
  - Mustache renderer: 144 assertions passed  2.44ms
  - TDocVariant: no assertion  60us
  - BSON: no assertion  362us
  - TSynTableStatement: 206 assertions passed  433us
  - TSynMonitorUsage: 1,202 assertions passed  384us
  Total failed: 0 / 285,559  - Low level types PASSED  202.85ms

 1.3. Cryptographic routines:
  - Adler32: 1 assertion passed  64us
  - MD5: 86 assertions passed  386us
  - SHA1: 10 assertions passed  5.03ms
  - SHA256: 8 assertions passed  8.23ms
  - AES256: 12,790 assertions passed  202.19ms
      cypher 1..9 bytes with AES-NI: 326us, without: 322us
  - RC4: 1 assertion passed  129us
!  - Base64: 3 / 11,994 FAILED  132.82ms
  - CompressShaAes: 1,683 assertions passed  2.36ms
  Total failed: 3 / 26,573  - Cryptographic routines FAILED  355.60ms

 1.4. Compression:
  - In memory compression: 12 assertions passed  309.70ms
!  - GZIP format: 1 / 19 FAILED  631.44ms
!  - ZIP format: 7 / 79 FAILED  2.41s
!  - SynLZO: 1,000 / 3,006 FAILED  113.31ms
!  - SynLZ: 989 / 32,221 FAILED  593.68ms
  Total failed: 1,997 / 35,337  - Compression FAILED  4.06s


2. mORMot

 2.1. File based:
  - Database direct access: 20,251 assertions passed  114.86ms
  - Virtual table direct access: 12 assertions passed  1.28ms
  - TSQLTableJSON: 144,070 assertions passed  96.73ms
  - TSQLRestClientDB: 608,193 assertions passed  2.93s
  - TRecordVersion: 20,060 assertions passed  147.49ms
  Total failed: 0 / 792,586  - File based PASSED  3.29s

 2.2. File based memory map:
  - Database direct access: 20,246 assertions passed  123.68ms
  - Virtual table direct access: 12 assertions passed  1.05ms
  - TSQLTableJSON: 144,070 assertions passed  91.37ms
  - TSQLRestClientDB: 608,192 assertions passed  2.65s
  - TRecordVersion: 20,060 assertions passed  152.44ms
  Total failed: 0 / 792,580  - File based memory map PASSED  3.02s

 2.3. File based WAL:
  - Database direct access: 20,251 assertions passed  133.37ms
  - Virtual table direct access: 12 assertions passed  843us
  - TSQLTableJSON: 144,070 assertions passed  94.39ms
  - TSQLRestClientDB: 608,193 assertions passed  2.82s
  - TRecordVersion: 20,060 assertions passed  121.04ms
  Total failed: 0 / 792,586  - File based WAL PASSED  3.18s

 2.4. Memory based:
  - Database direct access: 20,246 assertions passed  121.64ms
  - Virtual table direct access: 12 assertions passed  1.01ms
  - TSQLTableJSON: 144,070 assertions passed  93.11ms
  - TSQLRestClientDB: 676,500 assertions passed  3.65s
  - TRecordVersion: 20,060 assertions passed  133.22ms
  - RTree: 140,000 assertions passed  703.51ms
  - Shard write: 10,602 assertions passed  325.88ms
  - Shard read: 140,001 assertions passed  435.09ms
  - Shard read after purge: 114,003 assertions passed  357.40ms
  Total failed: 0 / 1,265,494  - Memory based PASSED  5.83s

 2.5. Basic classes:
!  - TSQLRecord: 5 / 88 FAILED  1.04ms
  - TSQLRecordSigned: 200 assertions passed  5.96ms
  - TSQLModel: 16 assertions passed  306us
!  - TSQLRestServerFullMemory: 370,119 / 640,135 FAILED  4.25s
  Total failed: 370,124 / 640,439  - Basic classes FAILED  4.26s

 2.6. Client server access:
  - TSQLHttpServer: 2 assertions passed  3.60ms
     using HTTP API 2.0
  - TSQLHttpClient: 3 assertions passed  14.26ms
     using TSQLHttpClientWinHTTP
  - HTTP client keep alive: 3,087 assertions passed  193.11ms
     4818 B, first 1.75ms, done 181.18ms i.e. 5519/s, aver. 181us, 25.8 MB/s
  - HTTP client multi connect: 3,087 assertions passed  186.86ms
     4818 B, first 304us, done 178.70ms i.e. 5595/s, aver. 178us, 26.1 MB/s
  - HTTP client encrypted: 3,087 assertions passed  221.89ms
     4818 B, first 321us, done 213.12ms i.e. 4692/s, aver. 213us, 21.9 MB/s
  - Named pipe access: 3,089 assertions passed  570.31ms
     4818 B, first 274.55ms, done 88.43ms i.e. 11307/s, aver. 88us, 52.8 MB/s
!  - Local window messages: 1 / 2 FAILED  1.40ms
  - Direct in process access: 3,056 assertions passed  57.13ms
     4818 B, first 67us, done 40.08ms i.e. 24949/s, aver. 40us, 116.6 MB/s
  - HTTP several DB servers: 9,604 assertions passed  779.11ms
     4818 B, first 437us, done 209.43ms i.e. 4774/s, aver. 209us, 22.3 MB/s
     4818 B, first 334us, done 195.50ms i.e. 5115/s, aver. 195us, 23.9 MB/s
     4818 B, first 305us, done 195.20ms i.e. 5122/s, aver. 195us, 23.9 MB/s
  Total failed: 1 / 25,017  - Client server access FAILED  2.04s

 2.7. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  1.02ms
!  - Service initialization: 1 / 17 FAILED  3.76ms
  - Direct call: 537,186 assertions passed  43.56ms
!  - Server side: 1 / 3 FAILED  180us
! Service oriented architecture - Client side REST
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create(): IComplexCalculator interface or TSQLRestRouti
ngREST routing not supported by server: {
"errorCode":400,
"errorText":"Bad Request"
}
! Service oriented architecture - Client side REST as JSON object
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Client side REST sessions stats
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
  - Client side REST locked: 3 assertions passed  3.64ms
  - Client side REST main thread: 3 assertions passed  15.80ms
! Service oriented architecture - Client side REST background thread
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Client side REST weak authentication
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Client side REST basic authentication
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Client side REST custom record layout
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Client side REST service log to DB
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Client side JSONRPC
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create: IComplexCalculator.TestBlob sicClientDriven mod
e not allowed with TServiceCustomAnswer result
! Service oriented architecture - Test over HTTP
! Exception EServiceException raised with messsage:
!  TServiceFactoryClient.Create(): IComplexCalculator interface or TSQLRestRouti
ngREST routing not supported by server: {
"errorCode":400,
"errorText":"Bad Request"
}
!  - Security: 52 / 135 FAILED  1.81ms
  - Mocks and stubs: 30,030 assertions passed  56.43ms
  Total failed: 58 / 567,460  - Service oriented architecture FAILED  154.02ms

 2.8. Bidirectional remote connection:
  - Websockets JSON protocol: 60 assertions passed  665us
  - Websockets binary protocol: 240 assertions passed  470us
  - Run http server: 2 assertions passed  415us
  - SOA callback on server side: 4,578 assertions passed  2.33ms
! Bidirectional remote connection - SOA callback via JSON websockets
! Exception EInterfaceFactoryException raised with messsage:
!  TInterfacedObjectFakeClient.FakeCall(IBidirService.TestCallback) failed: '{
"errorCode":500,
"error":
{"EAccessViolation":{"EAccessViolation":"Access violation"}}
}'
! Bidirectional remote connection - SOA callback via binary websockets
! Exception EInterfaceFactoryException raised with messsage:
!  TInterfacedObjectFakeClient.FakeCall(IBidirService.TestCallback) failed: '{
"errorCode":500,
"error":
{"EAccessViolation":{"EAccessViolation":"Access violation"}}
}'
  - TRecordVersion: 20,068 assertions passed  225.88ms
  Total failed: 0 / 29,366  - Bidirectional remote connection PASSED  297.92ms

 2.9. External database:
  - TQuery: 2,003 assertions passed  11.48ms
! External database - SynDBRemote
! Exception ESQLDBRemote raised with messsage:
!  You do not have the right to be here
  - DB properties persistence: 7 assertions passed  1.45ms
  - External records: 2 assertions passed  508us
  - Auto adapt SQL: 942 assertions passed  60.72ms
  - Crypted database: 253,275 assertions passed  175.09ms
  - External via REST: 170,354 assertions passed  811.34ms
  - External via virtual table: 170,354 assertions passed  1.29s
  - External via REST with change tracking: 180,454 assertions passed  1.79s
  - JET database: 7,007 assertions passed  716.52ms
  Total failed: 0 / 789,413  - External database PASSED  4.90s

 2.10. Multi thread process:
  - Create thread pool: 1 assertion passed  3.86ms
  - TSQLRestServerDB: 4,822 assertions passed  82.84ms
     1=20458/s  2=35220/s  5=34955/s  10=37993/s  30=42069/s  50=40164/s
  - TSQLRestClientDB: 4,822 assertions passed  1.46s
     1=34106/s  2=18021/s  5=6874/s  10=2872/s  30=886/s  50=523/s
  - TSQLRestClientURINamedPipe: 2,412 assertions passed  1.76s
     1=1300/s  2=987/s  5=478/s
!  - TSQLRestClientURIMessage: 18 / 40 FAILED  27.26ms
     1=215053/s  2=157728/s  5=95900/s  10=64745/s
  - Windows API: 4,822 assertions passed  1.27s
     1=4868/s  2=7422/s  5=5376/s  10=2679/s  30=922/s  50=858/s
Runtime error 204 at $004131DB
Runtime error 204 at $004131DB
Runtime error 204 at $004131DB
Runtime error 204 at $004131DB
Runtime error 204 at $004131DB
Runtime error 204 at $004131DB
Runtime error 204 at $004131DB
  $004131DB
  $004131DB
  $004131DB
  $004131DB
  $004131DB
  $004131DB
  $004131DB






  $00629F9C
  $0062A207
  $00429E6B
  $0042A169
  $0042BEAA
  $0042BC5D
  $00629E95
  $0040FDEE
  $76C6338A

Michal

Offline

Board footer

Powered by FluxBB