You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 2016-03-04 14:22:40
- miab3
- Member
- From: Poland
- Registered: 2014-10-01
- Posts: 188
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
$76C6338AMichal
Offline
Pages: 1