Hello,
Am 02.09.2025 um 15:51 schrieb smith5646midrange@xxxxxxxxx:
Will it be faster to omit the order by clause and just let SQL hand back data in whatever order that it wants or would it be quicker to add an order by clause.
In general, less work means faster processing. So, not giving an order by will yield a performance increase. How much is hard to predict. Better measure yourself: This is a change which can easily be implemented.
The more interesting question is: Did you have a closer look what the eventual bottleneck is?
- IBM i creating temporary indexes/collecting a result set prior to sending any data?
- Network (remote locations with low bandwidth and high latency and maybe slight packet loss in between?)
- What exactly does the querying side do with previous day's data? Discard? How quickly is this happening?
- Maybe the bottleneck is the actual insert into the querying side's database? I/O or CPU bound?
Unless these questions are evaluated and answered, it's just guesswork to give any advice.
:wq! PoC
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
