You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Mike Needham <ne...@gmail.com> on 2019/07/01 20:32:05 UTC
Delete performance
Hi All,
I have a cache that has approx 2 million records and is stored as a
queryable object (SQL). What is the fastest way to perform deletes on this
cache? I have been using a SqlFielsQuery to issue a SQL delete statement
but that seems to be very slow? I add/update using a dataStreamer, is
there some equivalent for deletes?
Thanks in advance
--
*Don't be afraid to be wrong. Don't be afraid to admit you don't have all
the answers. Don't be afraid to say "I think" instead of "I know."*
Re: Delete performance
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
I think you can use ds.removeData(k) all right.
Regards,
--
Ilya Kasnacheev
вт, 2 июл. 2019 г. в 15:37, Mike Needham <ne...@gmail.com>:
> Is there an example of how to do that? I cannot find any sample code that
> does a delete using the streamer other than the ds.remove().
>
> On Tue, Jul 2, 2019 at 4:22 AM Ilya Kasnacheev <il...@gmail.com>
> wrote:
>
>> Hello!
>>
>> You can have a custom StreamReceiver that will remove entries from cache.
>> It's a pity we don't ship it by default.
>>
>> Regards,
>> --
>> Ilya Kasnacheev
>>
>>
>> пн, 1 июл. 2019 г. в 23:32, Mike Needham <ne...@gmail.com>:
>>
>>> Hi All,
>>>
>>> I have a cache that has approx 2 million records and is stored as a
>>> queryable object (SQL). What is the fastest way to perform deletes on this
>>> cache? I have been using a SqlFielsQuery to issue a SQL delete statement
>>> but that seems to be very slow? I add/update using a dataStreamer, is
>>> there some equivalent for deletes?
>>>
>>> Thanks in advance
>>>
>>> --
>>> *Don't be afraid to be wrong. Don't be afraid to admit you don't have
>>> all the answers. Don't be afraid to say "I think" instead of "I know."*
>>>
>>
>
> --
> *Don't be afraid to be wrong. Don't be afraid to admit you don't have all
> the answers. Don't be afraid to say "I think" instead of "I know."*
>
Re: Delete performance
Posted by Mike Needham <ne...@gmail.com>.
Is there an example of how to do that? I cannot find any sample code that
does a delete using the streamer other than the ds.remove().
On Tue, Jul 2, 2019 at 4:22 AM Ilya Kasnacheev <il...@gmail.com>
wrote:
> Hello!
>
> You can have a custom StreamReceiver that will remove entries from cache.
> It's a pity we don't ship it by default.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пн, 1 июл. 2019 г. в 23:32, Mike Needham <ne...@gmail.com>:
>
>> Hi All,
>>
>> I have a cache that has approx 2 million records and is stored as a
>> queryable object (SQL). What is the fastest way to perform deletes on this
>> cache? I have been using a SqlFielsQuery to issue a SQL delete statement
>> but that seems to be very slow? I add/update using a dataStreamer, is
>> there some equivalent for deletes?
>>
>> Thanks in advance
>>
>> --
>> *Don't be afraid to be wrong. Don't be afraid to admit you don't have all
>> the answers. Don't be afraid to say "I think" instead of "I know."*
>>
>
--
*Don't be afraid to be wrong. Don't be afraid to admit you don't have all
the answers. Don't be afraid to say "I think" instead of "I know."*
Re: Delete performance
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
You can have a custom StreamReceiver that will remove entries from cache.
It's a pity we don't ship it by default.
Regards,
--
Ilya Kasnacheev
пн, 1 июл. 2019 г. в 23:32, Mike Needham <ne...@gmail.com>:
> Hi All,
>
> I have a cache that has approx 2 million records and is stored as a
> queryable object (SQL). What is the fastest way to perform deletes on this
> cache? I have been using a SqlFielsQuery to issue a SQL delete statement
> but that seems to be very slow? I add/update using a dataStreamer, is
> there some equivalent for deletes?
>
> Thanks in advance
>
> --
> *Don't be afraid to be wrong. Don't be afraid to admit you don't have all
> the answers. Don't be afraid to say "I think" instead of "I know."*
>