Hi, it depends on many factors - row size, hardware setup, etc. I would try different batch sizes and compare the performance to find the optimal approach.
On Wed, 13 Nov 2024, 05:07 , <satyajit.man...@barclays.com> wrote: > Hi Pavel, > > > > Can you advise which is the optimum way to Query 1 million > record if we have 1 million cache keys available. Shall we use GetAll > and pass all 1 million keys or it should be queried in batches. > Performance is important. > > > > Thanks > > Satyajit > > > > > > Barclays Execution Services Limited registered in England. Registered No. > 1767980. Registered office: 1 Churchill Place, London, E14 5HP > > Barclays Execution Services Limited provides support and administrative > services across Barclays group. Barclays Execution Services Limited is an > appointed representative of Barclays Bank UK plc and Barclays Bank plc. > Barclays Bank UK plc and Barclays Bank plc are authorised by the Prudential > Regulation Authority and regulated by the Financial Conduct Authority and > the Prudential Regulation Authority. > > This email and any attachments are confidential and intended solely for > the addressee and may also be privileged or exempt from disclosure under > applicable law. If you are not the addressee, or have received this email > in error, please notify the sender and immediately delete it and any > attachments from your system. Do not copy, use, disclose or otherwise act > on any part of this email or its attachments. > > Internet communications are not guaranteed to be secure or virus-free. The > Barclays group does not accept responsibility for any loss arising from > unauthorised access to, or interference with, any internet communications > by any third party, or from the transmission of any viruses. Replies to > this email may be monitored by the Barclays group for operational or > business reasons. > > Any opinion or other information in this email or its attachments that > does not relate to the business of the Barclays group is personal to the > sender and is not given or endorsed by the Barclays group. > > Unless specifically indicated, this e-mail is not an offer to buy or sell > or a solicitation to buy or sell any securities, investment products or > other financial product or service, an official confirmation of any > transaction, or an official statement of Barclays. >
