You might also want to consider using third-party persistence (external-storage <https://ignite.apache.org/docs/latest/persistence/external-storage>) instead of “manually” reading/writing from Oracle.
> On 4 May 2022, at 07:11, Reshma Bochare <rboch...@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 > 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.