Hi Zhenya, Thanks for replying. It was not actually typo. We are thinking to start stand-alone servers of 32 GB and then if more memory is required it will store onto the disk hence I said persistence mode enabled
Will it work in this way? Thanks, Reshma. From: Zhenya Stanilovsky <arzamas...@mail.ru> Sent: Thursday, May 5, 2022 1:22 PM To: user@ignite.apache.org Subject: [EXTERNAL] Re[2]: Is apache ignite suitable for sql querying on ignite cache? Yes, it`s suitable, seems there is a typo here: (Like memory store, persistence mode enabled) — hope you wand to say : persistence mode disabled. You might also want to consider using third-party persistence (external-storage<https://urldefense.com/v3/__https:/ignite.apache.org/docs/latest/persistence/external-storage__;!!JqsUqw!1lVA1f6T4EjHTCc-DFDd5ewE321VQJQ6E2I6qEu8n7Ive7AtyYSs0ItXD1jSEY_AFYQdI1bMQJzuDtW5Iw$>) instead of “manually” reading/writing from Oracle. On 4 May 2022, at 07:11, Reshma Bochare <rboch...@csod.com<file://e.mail.ru/compose/%3fmailto=mailto%253arboch...@csod.com>> wrote: Hi Team, Could you please help me with the below use case. Thanks, Reshma. From: Reshma Bochare Sent: Thursday, April 28, 2022 4:52 PM To: user@ignite.apache.org<file://e.mail.ru/compose/%3fmailto=mailto%253au...@ignite.apache.org> Subject: Is apache ignite suitable for sql querying on ignite cache? Hi Team, We want to use apache ignite for below use case. We provide reports to customer . We execute query on oracle and feed it into oracle. And on the top of report, we allow pagination, sorting, grouping and export etc. Right now for each and every action after report execution, we hit oracle to get data. So we want we will hit oracle once and get data in memory and execute query on memory data to get data of further operations like pagination, sorting, grouping and export . To achieve this, I am thinking to use of apache ignite as below 1. We execute query on oracle database and want to save that data into apache ignite as cache. (Like memory store, persistence mode enabled) 2. And on ignite cache, execute some complicated queries and fetch data from ignite cache. 3. Keep the expiry of this cache to 5 minutes. 4. So there will be lot of insertion of new data and at the same time get of cache also like User executes report and performs some grouping, and closes report. In this case we will create cache in ignite and keep in the memory till user closes it. Meanwhile perform sql queries on ignite cache. 5. For cache, considering creating class with different data types fields to it. And perform query on this class Is it apache ignite suitable for this use case.? Thanks, Reshma. This message, together with any attachments, is intended only for the use of the individual or entity to which it is addressed and may contain confidential and/or privileged information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this message, or any attachment, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete the message, together with any attachments, from your computer. Thank you for your cooperation. ________________________________ *EXTERNAL MESSAGE WARNING: This email originated from outside of Cornerstone. Do not click links or open attachments unless you recognize the sender and know the content is safe. Please see this wiki for more information on email safety: https://wiki.cornerstoneondemand.com/display/ISS/Security+Awareness
