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 ) 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.
