Some testing after optimisation...

[Sten-Erik Björling]

Dear all,

Done some testing and developed some optimisations for JS-based projects also supporting REST access.

Some caveats…

- These tests run from a developer version of Omnis set to run as a server.
- Developer license - 5 simultaneous users.
- Local DB is Postgres 15
- Tests are performed to evaluate internal workloads for Omnis and PostgreSQL - external latencies are not considered.
- Computer: Apple MacBook Pro Max, 64 GB memory, 400 GB/sec memory bandwidth, database completely cached.
- Test database - DVD Rental example database, functions created for most of the tested routines (optimised by the PG server).
- Utilising session pools and first efforts to optimise session pool settings.

Some figures - performing REST calls:

- Sales aggregates for an artist across genres (sales transactions about 16 000 records, 7 table join) - 230 transactions/second. Omnis workload for one processor - 62%, 5 Postgres instances 10-15 % at average each.

- Loading of an actor record (small, but anyway) - 1020 transactions/second.

- Max Load test - loading a list-line from memory - 1900 transactions / second.

Of course, this performance is not across the Internet at the end-users - latencies etc. come in as factors.

Some thoughts… This performance was achieved by one instance of Omnis utilising 60-70% of one processor core and 5 sessions of Postgres were involved. Both these figures can be drastically increased on modern computers. Introduce load balancing for Omnis, and a more extensive license can do a lot.

Some thoughts on computers…

Apple MX, due to its very high memory bandwidth performance (Mac Studio Ultra has a memory bandwidth of 800 GB/sec) can with low energy consumption deliver very high functionality and performance in this scenario may be as low as 30-40 W for a system running on full capacity. Suitable for a bookshelf… :-) and even a MacMini can perform very well in many user scenarios...

Impressive results!!

Take care all, all the best…

Stene

______

Sten-Erik Björling
Enviro Data
Kyrkogatan 5A 2 tr
SE-972 32  Luleå
Sweden

E-Mail: s-e.bjorling at enviro.se
Mobile: +46-70-655 11 72
Wire: @stenerikbjorling
Skype: stenerikbjorling
iChat: stene at icloud.com
Signal: +46 70 655 11 72
FaceTime: stene at icloud.com
Telegram: @stenerikbjorling
Hotmail / Messenger: stenerikbjorling at hotmail.com
GMail: stenerikbjorling at gmail.com
______

This email and any files transmitted with it are confidential, may be legally privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please note that any use, distribution, or reproduction of the contents of this email is strictly prohibited and may be unlawful. If you are not the intended recipient, please notify the sender by return email and destroy all copies of the original message including any attachments thereto. Thank you.

Please note that we take reasonable precautions to prevent the transmission of viruses; however, we cannot guarantee that this email or its attachments are free from viruses. We only send and receive emails on the basis that we are not be liable for any loss or damage resulting from the opening of this message and/or attachments.