An interesting example of performance using SQL workers and different tricks...

Sten-Erik Björling s-e.bjorling at
Mon Nov 28 17:47:11 UTC 2022

Hi Doug,

I did not compare it with earlier versions. Kindly note that this test covered Omnis server as a REST server so processing on the Omnis side was performed as well.

Heavy use if optimised and customised session pools and not worker objects. Will try to get the worker objects to work which seems to be a bit tricky due to the callback methods of REST management. That approach resulted in around 700 calls a second but were not able to send the results, just performing the worker object search and internal result delivery.

Take care, all the best…



> 28 nov. 2022 kl. 18:07 skrev Doug Easterbrook via omnisdev-en <omnisdev-en at>:
> hi Sten
> Are you comparing this to earlier postgres performance, or just pleasantly surprised at what the M1 mac’s can do vis-a-vis performance.
> I have 14.6 on my machine - I haven’t taken the jump to the next version — so I wanted to know if I should be looking for something noticeable (I hope so)
> Doug Easterbrook
> Arts Management Systems Ltd.

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

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

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.

More information about the omnisdev-en mailing list