ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavel Tupitsyn <ptupit...@apache.org>
Subject Re: New blog post: ADO.NET Ignite Cache Store
Date Wed, 31 May 2017 10:43:14 GMT
You have to handle the deletion manually in some way or another:
delete entry from Ignite when deleting it from DB, or use some DB change
listener.

On Wed, May 31, 2017 at 1:13 PM, Chetan D <cchetands@gmail.com> wrote:

> Hi Pavel,
>
> I was going through all methods and trying to implement cache using
> ado.net while doing that i came across some scenario which are as follows,
>
> 1.Data is added to cache and when trying to retrieve it using key first it
> checks if it is present in cache then gets it from cache if not then there
> will be a db call and fetches the data from DB and stores it in cache which
> again follows for the next time as well.
>
> 2. The second scenario is i have loaded cache with two values from DB
> taking your cars table as example.Once i have loaded cache then i went
> ahead and deleted a record from DB.
> so when i use a get() method by passing the key which i deleted in DB it
> actually shows me the value which because it is present in cache.
>
> so my question is when there is a record deleted in DB it should be
> deleted in cache. when user tries to retrieve any information which is not
> there in DB it should not be displayed from cache as well.
>
>
> Can you please guide me how to handle this.
>
> Regards
> Chetan D
>
>
>
> On Tue, May 30, 2017 at 5:36 PM, Pavel Tupitsyn <ptupitsyn@apache.org>
> wrote:
>
>> Basically, data streamer does the same thing as cache.Put() in a loop.
>> Data streamer is more efficient on large amounts of keys.
>>
>> 1) Yes, I guess there is no different than using tables
>> 2) Data streamer performs batched updates. IDataStreamer.PerNodeBufferSize
>> controls how many entries are batched before being sent to remote nodes.
>> 3) Once the streaming is complete (IDataStreamer.Flush() or
>> IDataStreamer.Close(false)), all data is guaranteed to be in the cache. So
>> you can do cache.Get.
>>
>> On Tue, May 30, 2017 at 2:49 PM, Chetan D <cchetands@gmail.com> wrote:
>>
>>> Hi Pavel,
>>>
>>> Thank you for the quick response.
>>> I tried using data streamer to get all the values in a table and store
>>> it in cache. while i was doing that i came across a situation where in i
>>> need to store data to cache from SQL VIEWS.
>>>
>>> 1.Is it possible to load cache from sql views?
>>> 2.with respect to data streamer, when i use AddData() method will it add
>>> data to cache which i specified while creating data streamer  or the data
>>> will be stored in data streamer itself?
>>> 3. when i use data streamer  can i use the same way such as cache.get()
>>> method or by using a foreach loop to get cache or is it different with
>>> respect to datastreamer?
>>>
>>>
>>> Regards
>>> Chetan D
>>>
>>>
>>>
>>>
>>> On Mon, May 29, 2017 at 6:45 PM, Pavel Tupitsyn <ptupitsyn@apache.org>
>>> wrote:
>>>
>>>> 1) ICache implements IEnumerable, so you can do `foreach (var entry in
>>>> cache)` or `cache.ToList()`.
>>>> 2) To bulk load the data into cache you can either use IDataStreamer
>>>> [1] or, in case with cache store, ICacheStore.LoadCache method.
>>>> 3) No, you have to handle this manually.
>>>> 4) GetAll returns multiple cache entries by a set of known keys.
>>>>
>>>> [1] https://apacheignite-net.readme.io/docs/data-streamers
>>>>
>>>> On Mon, May 29, 2017 at 3:28 PM, Chetan D <cchetands@gmail.com> wrote:
>>>>
>>>>> Hi Pavel,
>>>>>
>>>>> Thanks for the quick response. code helped me a lot.
>>>>> I have some general questions,
>>>>>
>>>>> 1.is it possible to get all data stored in cache without calling
>>>>> explicit get method if so how?
>>>>> 2.can i fetch all data from sql table and store it in cache without
>>>>> using any of the loops such as for each.
>>>>> 3.if i add any data in table will my cache gets updated automatically?
>>>>> 4.how can i make use of GetAll() method? will this fetch all cache
>>>>> data?
>>>>>
>>>>> Regards
>>>>> Chetan D
>>>>>
>>>>> On Fri, May 26, 2017 at 10:36 PM, Pavel Tupitsyn <ptupitsyn@apache.org
>>>>> > wrote:
>>>>>
>>>>>> Short writeup with example code, inspired by user questions:
>>>>>>
>>>>>> ADO.NET + Binary Mode Cache Store
>>>>>> https://ptupitsyn.github.io/Ado-Net-Cache-Store/
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>

Mime
View raw message