mORMot Open Source

PBa

Member

From: Austria

Registered: 2017-01-04

Posts: 18

TestSQL3.exe needs more than 10 minutes to finish

What is an average time for TestSQL3.exe to finish all tests?
I know that this will depend on several aspects like hardware used ...

Currently I have to wait more than 10 minutes until the execution of TestSQL3.exe is finished. Particularly 2.7 Test over HTTP needs 514 seconds and 2.12 Multi threaded clients test need 43 seconds to finish (see protocol for Delphi 7 below, the same is true for Delphi 10.1 Berlin and Delphi 10.2 Tokyo).
Is this a reasonable time to execute? If no what could be the problem?

Thank you very much!
Paul

2.7. Service oriented architecture:
  - Weak interfaces: 56 assertions passed  37us
  - ...
  - Client side JSONRPC: 794,733 assertions passed  883.06ms
  - Test over HTTP: 10,477 assertions passed  514.97s
  - Security: 139 assertions passed  1.63ms
  - Mocks and stubs: 30,032 assertions passed  40.95ms
  Total failed: 0 / 13,948,805  - Service oriented architecture PASSED  531.63s

2.12. DDD multi thread:
  - Delete old database: 1 assertion passed  83us
  - Start server: 1 assertion passed  46.63ms
  - Single client test: 1,002 assertions passed  9.45s
  - Multi threaded clients test: 21 assertions passed  43.19s
  Total failed: 0 / 1,025  - DDD multi thread PASSED  52.69s

Using mORMot 1.18.4080 ERTL FTS3
Running on Windows 7 64bit SP1 (6.1.7601) with code page 1252
TSQLite3LibraryStatic 3.21.0 with internal MM
Generated with: Delphi 7 compiler

Time elapsed for all tests: 670.85s
Performed 2017-12-14 12:13:56 by Paul on PC

Total assertions failed for all test suits:  0 / 33,251,531
! All tests passed successfully.

---------------

Using mORMot 1.18.4080 FTS3
Running on Windows 7 64bit SP1 (6.1.7601) with code page 1252
TSQLite3LibraryStatic 3.21.0 with internal MM
Generated with: Delphi 10.2 Tokyo compiler

Time elapsed for all tests: 818.34s
Performed 2017-12-14 11:53:06 by Paul on PC

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: TestSQL3.exe needs more than 10 minutes to finish

From that numbers, I guess there is something wrong with your network access.
Perhaps your antivirus software is using a lot of resources.

Try to exclude the TestSQL3.exe from your antivirus list.

Here are my actual numbers, on my laptop:

Using mORMot 1.18.4084 FTS3
Running on Windows 10 64bit (10.0.16299) with code page 1252
TSQLite3LibraryStatic 3.21.0 with internal MM
Generated with: Delphi XE7 compiler

Time elapsed for all tests: 81.36s
Performed 2017-12-14 15:01:59 by User on ACER

Total assertions failed for all test suits:  0 / 33,861,335

Full text at https://paste.ubuntu.com/26183268/