You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by adumalagan <an...@gmail.com> on 2020/12/02 17:41:30 UTC
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Hi Vlad, I've started to read through your link and I just wanted to know
that, if I were to implement your tutorial, could I perform SQL queries on
the cache after loading?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by adumalagan <an...@gmail.com>.
Unfortunately, db work is out of the scope of my responsibility, and I was
just told to work around the issue
Hence me asking about Colocation and MapReduce
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by Pavel Tupitsyn <pt...@apache.org>.
> Colocation by Partition, but that API is not available for C#
Partition-based APIs were added in Ignite 2.9 [1]
> Is it possible to speed up loading cache by using Binary Object +
Colocating by Key, or Binary Object + MapReduce API?
Probably yes. But have you sorted out the DB connection bottleneck?
Let's make sure we are fixing the right problem.
[1]
https://ignite.apache.org/releases/latest/dotnetdoc/api/Apache.Ignite.Core.Compute.ICompute.html#Apache_Ignite_Core_Compute_ICompute_AffinityCall__1_System_Collections_Generic_IEnumerable_System_String__System_Int32_Apache_Ignite_Core_Compute_IComputeFunc___0__
On Thu, Dec 3, 2020 at 7:09 PM adumalagan <an...@gmail.com> wrote:
> Thank you for the clarification!
>
> For this use case where data is being pulled from an underlying RDBMS and
> instantiated as an Associate object, is it possible to work the Associate
> object as a Binary Object similar to what you've done here?
>
> Also, I see than in Vladamir's loading example, he uses the Colocation by
> Partition, but that API is not available for C#. Is it possible to speed up
> loading cache by using Binary Object + Colocating by Key, or Binary Object
> + MapReduce API?
>
> ------------------------------
> Sent from the Apache Ignite Users mailing list archive
> <http://apache-ignite-users.70518.x6.nabble.com/> at Nabble.com.
>
>
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by adumalagan <an...@gmail.com>.
Thank you for the clarification!
For this use case where data is being pulled from an underlying RDBMS and
instantiated as an Associate object, is it possible to work the Associate
object as a Binary Object similar to what you've done here?
Also, I see than in Vladamir's loading example, he uses the Colocation by
Partition, but that API is not available for C#. Is it possible to speed up
loading cache by using Binary Object + Colocating by Key, or Binary Object +
MapReduce API?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by Pavel Tupitsyn <pt...@apache.org>.
Vladimir,
> I do not use SQL because my interest is to get max performance, I use
key-value API instead
> The same reason is why I use Java
I don't think we should downplay SQL and C# APIs like this - it can be
misleading to our users.
SQL can be faster than key-val API (e.g. index lookups), and C# API is on
par with Java (thin client is a bit faster, AFAIR).
On Thu, Dec 3, 2020 at 12:11 PM Pavel Tupitsyn <pt...@apache.org> wrote:
> > are there C# equivalencies to the Java interfaces BinaryObject and
> Affinity
>
> Yes, please see IIgnite.GetAffinity [1] and GetBinary [2].
>
> [1]
> https://ignite.apache.org/releases/latest/dotnetdoc/api/Apache.Ignite.Core.IIgnite.html#Apache_Ignite_Core_IIgnite_GetAffinity_System_String_
> [2]
> https://ignite.apache.org/releases/latest/dotnetdoc/api/Apache.Ignite.Core.IIgnite.html#Apache_Ignite_Core_IIgnite_GetBinary
>
> On Thu, Dec 3, 2020 at 8:55 AM <vt...@gmail.com> wrote:
>
>> Hi,
>>
>> I do not use SQL because my interest is to get max performance, I use
>> key-value API instead. The same reason is why I use Java - it is native for
>> Ignite. I think there should be wrappers forBinaryObject and Affinity in c#.
>>
>> Vladimir
>>
>> 4:39, 3 декабря 2020 г., adumalagan <an...@gmail.com>:
>>
>> I see, thanks for the clarification!
>>
>> I also have another question - are there C# equivalencies to the Java
>> interfaces BinaryObject and Affinity?
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>>
>>
>> --
>> Отправлено из мобильного приложения Яндекс.Почты
>>
>
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by Pavel Tupitsyn <pt...@apache.org>.
> are there C# equivalencies to the Java interfaces BinaryObject and
Affinity
Yes, please see IIgnite.GetAffinity [1] and GetBinary [2].
[1]
https://ignite.apache.org/releases/latest/dotnetdoc/api/Apache.Ignite.Core.IIgnite.html#Apache_Ignite_Core_IIgnite_GetAffinity_System_String_
[2]
https://ignite.apache.org/releases/latest/dotnetdoc/api/Apache.Ignite.Core.IIgnite.html#Apache_Ignite_Core_IIgnite_GetBinary
On Thu, Dec 3, 2020 at 8:55 AM <vt...@gmail.com> wrote:
> Hi,
>
> I do not use SQL because my interest is to get max performance, I use
> key-value API instead. The same reason is why I use Java - it is native for
> Ignite. I think there should be wrappers forBinaryObject and Affinity in c#.
>
> Vladimir
>
> 4:39, 3 декабря 2020 г., adumalagan <an...@gmail.com>:
>
> I see, thanks for the clarification!
>
> I also have another question - are there C# equivalencies to the Java
> interfaces BinaryObject and Affinity?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>
>
> --
> Отправлено из мобильного приложения Яндекс.Почты
>
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by vt...@gmail.com.
Hi,
I do not use SQL because my interest is to get max performance, I use key-
value API instead. The same reason is why I use Java - it is native for
Ignite. I think there should be wrappers forBinaryObject and Affinity in c#.
Vladimir
4:39, 3 декабря 2020 г., adumalagan <an...@gmail.com>:
> I see, thanks for the clarification!
>
> I also have another question - are there C# equivalencies to the Java
> interfaces BinaryObject and Affinity?
>
>
>
>
>
> \--
> Sent from: [http://apache-ignite-users.70518.x6.nabble.com/](http://apache-
ignite-users.70518.x6.nabble.com)
>
\--
Отправлено из мобильного приложения Яндекс.Почты
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by adumalagan <an...@gmail.com>.
I see, thanks for the clarification!
I also have another question - are there C# equivalencies to the Java
interfaces BinaryObject and Affinity?
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Re: C# CacheStoreAdapter - Customizing Load, LoadCache methods
Posted by Denis Magda <dm...@apache.org>.
Yes, once the data is loaded into Ignite you can query it with SQL.
-
Denis
On Wed, Dec 2, 2020 at 9:41 AM adumalagan <an...@gmail.com> wrote:
> Hi Vlad, I've started to read through your link and I just wanted to know
> that, if I were to implement your tutorial, could I perform SQL queries on
> the cache after loading?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>