[Fatal Error] TestSQL3.dpr(79) File Not Found 'FastMM4.dcu' ?

Sbleck · 2013-01-02 14:47:18

Hello,

I´m only an Oracle DBA that was researching a lot in the few spare time that I have, only to be possible to know where are the causes of bad performance problems that could happen in some Oracle databases, caused by no enough optimized application. Currently, I´m not a Delphi/VB developer, but I´m trying to to my best in building some examples to compare some technologies (ADO, dbExpress, ODBC) to be possible to show to the developers how should be the applications being developed, regarding to obtain the desired performance, too. This was the main reason of trying to use what was offered by mORMot, after reading about what the mORMot framework offered (through 'SynDBOracle: Open Source native Oracle access', as like as was mentioned in this link: http://blog.synopse.info/post/2011/07/0 … le-access):

"
Direct access to the Oracle Call Interface (OCI) client, with no BDE, Midas, DBExpress, nor OleDB or ODBC provider necessary;
.......
"

Than, I downloaded it, unpacked it as suggested and mentioned below:

Well, I´ve done all steps until the step 4, when the problem mentioned in the subject of this post happened. Please note that I´m not a developer and I´m using the standard (as-is) Delphi 7 environment, having SP1 installed, too.

Please let me know how could this problem be solved and if there is more complete and maybe ready-to-run examples available, for being possible to a newcomer to this technology easily understand how to use it.

Regards,
Sven

ab · 2013-01-02 16:30:22

FastMM4 is a fast heap memory manager, provided by http://sourceforge.net/projects/fastmm

It is included since Delphi 2006.
But for Delphi 7, you need to download the file and include it in your Delphi libraries (e.g. D:\Dev\Synopse).

I've modified the REadMe.txt file to reflect explicitly this requirement.
See http://synopse.info/fossil/info/51a781c561

Thanks for the feedback and interest.

ab · 2013-01-02 16:45:09

If you check out http://blog.synopse.info/post/2012/07/1 … erformance and http://blog.synopse.info/post/2012/09/1 … figuration you can see that you can achieve more than 50,000 inserts per seconds with array binding with our SynDBOracle unit.

This technology is also available in JDBC, and probably some .Net direct providers (not OleDB).

Oracle is amazing, even if difficult to master.
I'm a developer since years, but have very rude notions of DBA.
From the programming point of view, the Oracle client is huge if you need all the options, but the Oracle Instant Client is much smaller, do not need any installation, and is very efficient. Directly using it, as mORMot layer does, is a huge benefit for deployment, and even speed.
With our classes, CPU and memory use at client level is also very low. Thanks to direct access to the Oracle Client.

Also check out SynDBExplorer.
See http://blog.synopse.info/?q=syndbexplorer

Sbleck · 2013-01-02 16:52:38

ab wrote:

FastMM4 is a fast heap memory manager, provided by http://sourceforge.net/projects/fastmm
It is included since Delphi 2006.
But for Delphi 7, you need to download the file and include it in your Delphi libraries (e.g. D:\Dev\Synopse).
I've modified the REadMe.txt file to reflect explicitly this requirement.
See http://synopse.info/fossil/info/51a781c561
Thanks for the feedback and interest.

Hello,

Thanks for your comments, but before wasn´t clear enough for a newcomer how to deal with all these requirements, having a standard environment. Than, I tried a lot of try-and-errors to be possible to find a way to put all these things to work, properly. Even for downloading all the requirements wasn´t so obvious, too.

What I´ve done was:

1) Readed again the steps mentioned before, to see of some detail was not paid enough attention;
2) Tried to find the mentioned RTL7 and LVCL, as was mentioned in another post (' RTL7 and LVCL directories added': http://synopse.info/forum/viewtopic.php?id=30);
3) Downloaded the entire package, as was mentioned behind a lot of other links: http://synopse.info/fossil/zip/mORMot%2 … 966ea9ba46
4) Unpacked again, in the place that I have put at first time: C:\Synopse
5) Paid attention to put togheter the other files, inside that folder (C:\Synopse);
6) Changed the Library path (in Tools->Environment Options->Library TAB) to reflect the latest changes: C:\Synopse\mORMotOpenSource;C:\Synopse\mORMotOpenSource\RTL7;C:\Synopse\mORMot\SQLite3...

Than and only than was possible to see some things run, as expected:

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

1. Synopse libraries

1.1. Low level common:
- System copy record: 22 assertions passed 13.79ms
- TDynArray: 959,438 assertions passed 319.21ms
- TDynArrayHashed: 1,200,629 assertions passed 242.53ms
- Fast string compare: 7 assertions passed 235us
- IdemPropName: 10 assertions passed 277us
- Url encoding: 105 assertions passed 2.06ms
- IsMatch: 599 assertions passed 306us
- Soundex: 35 assertions passed 100us
- Numerical conversions: 784,912 assertions passed 394.22ms
- Curr64: 20,053 assertions passed 2.95ms
- CamelCase: 5 assertions passed 81us
- Bits: 4,614 assertions passed 135us
- Ini files: 7,004 assertions passed 108.89ms
- Unicode - Utf8: 61,082 assertions passed 1.37s
- Iso8601 date and time: 24,000 assertions passed 10.16ms
- Url decoding: 1,100 assertions passed 414us
- TSynTable: 41 assertions passed 13.25ms
- TSynCache: 404 assertions passed 283us
- TSynFilter: 1,005 assertions passed 3.67ms
- TSynValidate: 677 assertions passed 1.01ms
- TSynLogFile: 42 assertions passed 769us
Total failed: 0 / 3,065,784 - Low level common PASSED 2.49s

1.2. Low level types:
- RTTI: 34 assertions passed 11.13ms
- Url encoding: 200 assertions passed 1.30ms
- Encode decode JSON: 251,032 assertions passed 242.21ms
Total failed: 0 / 251,266 - Low level types PASSED 258.61ms

1.3. Big table:
- TSynBigTable: 19,181 assertions passed 321.55ms
- TSynBigTableString: 15,996 assertions passed 149.70ms
- TSynBigTableMetaData: 384,060 assertions passed 1.75s
- TSynBigTableRecord: 452,185 assertions passed 4.21s
Total failed: 0 / 871,422 - Big table PASSED 6.44s

1.4. Cryptographic routines:
- Adler32: 1 assertion passed 158us
- MD5: 1 assertion passed 163us
- SHA1: 5 assertions passed 163us
- SHA256: 5 assertions passed 179us
- AES256: 6,372 assertions passed 293.45ms
- Base64: 11,994 assertions passed 110.35ms
Total failed: 0 / 18,378 - Cryptographic routines PASSED 417.45ms

1.5. Compression:
- In memory compression: 12 assertions passed 266.39ms
- Gzip format: 19 assertions passed 535.24ms
- Zip format: 36 assertions passed 2.25s
- SynLZO: 3,006 assertions passed 120.74ms
- SynLZ: 13,016 assertions passed 596.39ms
Total failed: 0 / 16,089 - Compression PASSED 3.78s

1.6. Synopse PDF:
- TPdfDocument: 4 assertions passed 28.03ms
- TPdfDocumentGDI: 6 assertions passed 694.21ms
Total failed: 0 / 10 - Synopse PDF PASSED 725.96ms

2. mORMot

2.1. Basic classes:
- TSQLRecord: 52 assertions passed 614us
- TSQLRecordSigned: 200 assertions passed 5.48ms
- TSQLModel: 3 assertions passed 332us
Total failed: 0 / 255 - Basic classes PASSED 12.23ms

2.2. File based:
- Database direct access: 10,138 assertions passed 905.73ms
- Virtual table direct access: 12 assertions passed 47.33ms
- TSQLTableJSON: 19,030 assertions passed 155.40ms
- TSQLRestClientDB: 593,518 assertions passed 7.14s
Total failed: 0 / 622,698 - File based PASSED 8.26s

2.3. File based WAL:
- Database direct access: 10,138 assertions passed 762.87ms
- Virtual table direct access: 12 assertions passed 15.12ms
- TSQLTableJSON: 19,030 assertions passed 110.33ms
- TSQLRestClientDB: 593,518 assertions passed 6.82s
Total failed: 0 / 622,698 - File based WAL PASSED 7.71s

2.4. Memory based:
- Database direct access: 10,136 assertions passed 568.51ms
- Virtual table direct access: 12 assertions passed 15.29ms
- TSQLTableJSON: 19,030 assertions passed 104.18ms
- TSQLRestClientDB: 661,811 assertions passed 7.56s
Total failed: 0 / 690,989 - Memory based PASSED 8.26s

2.5. Client server access:
- TSQLHttpServer: 21 assertions passed 657.14ms
using THttpApiServer
- TSQLHttpClient: 3 assertions passed 278.03ms
- Http client keep alive: 3,084 assertions passed 834.86ms
4803 B, first 12.60ms, done 799.53ms i.e. 1250/s, aver. 799us, 5.8 MB/s
- Http client multi connect: 3,084 assertions passed 628.20ms
4803 B, first 830us, done 607.34ms i.e. 1646/s, aver. 607us, 7.7 MB/s
- Named pipe access: 3,086 assertions passed 661.39ms
4803 B, first 130.99ms, done 330.20ms i.e. 3028/s, aver. 330us, 14.1 MB/s
- Local window messages: 3,085 assertions passed 141.34ms
4803 B, first 177us, done 137.74ms i.e. 7259/s, aver. 137us, 33.9 MB/s
- Direct in process access: 3,053 assertions passed 84.21ms
4803 B, first 114us, done 80.03ms i.e. 12495/s, aver. 80us, 58.4 MB/s
Total failed: 0 / 15,416 - Client server access PASSED 3.31s

2.6. Service oriented architecture:
- Weak interfaces: 56 assertions passed 16.81ms
- Service initialization: 127 assertions passed 2.37ms
- Direct call: 602,472 assertions passed 90.73ms
- Server side: 602,482 assertions passed 86.21ms
- Client side REST: 602,484 assertions passed 1.42s
- Client side JSONRPC: 602,482 assertions passed 1.52s
- Client side synchronized REST: 602,482 assertions passed 3.23s
- Security: 135 assertions passed 2.72ms
- Custom record layout: 602,482 assertions passed 1.43s
- Mocks and stubs: 30,029 assertions passed 108.51ms
Total failed: 0 / 3,645,231 - Service oriented architecture PASSED 7.94s

2.7. External database:
- External records: 1 assertion passed 353us
- Auto adapt SQL: 168 assertions passed 24.54ms
- Crypted database: 253,275 assertions passed 697.68ms
- External via REST: 243,436 assertions passed 2.44s
- External via virtual table: 243,436 assertions passed 3.92s
Total failed: 0 / 740,316 - External database PASSED 7.10s

Synopse framework used: 1.18
SQlite3 engine used: 3.7.14
Generated with: Delphi 7 compiler

Time elapsed for all tests: 56.80s
Tests performed at 02/01/2013 14:25:44

Total assertions failed for all test suits: 0 / 10,560,552

! All tests passed successfully.
Done - Press ENTER to Exit
"

...

C:\Documents and Settings\Administrator>Cd\"Synopse\mORMotOpenSource\SQLite3"

C:\Synopse\mORMotOpenSource\SQLite3>dir
Volume in drive C is Server
Volume Serial Number is A8B4-4854