Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
From: Denis Magda <dmagda@gridgain.com>
Content-Type: multipart/alternative; boundary="Apple-Mail=_16FCC121-7615-4602-A283-9426A4D36A2D"
Message-Id: <3ACB067E-A329-4BB4-BA9B-E3F4D9CA17DD@gridgain.com>
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Using Apache Ingnite as RDBMS in memory Cache
Date: Fri, 17 Jun 2016 00:33:30 +0300
References: <CAKrcacGVRTwL6JhY_V6E_Xx61yvd3ZVNQtyeVgDkhB6ZuOpZ=Q@mail.gmail.com> <CAKrcacG1=-W6wcHajO01igVf2c8otUsGkdDpGBM45a7-oUKfRg@mail.gmail.com>
To: user@ignite.apache.org
In-Reply-To: <CAKrcacG1=-W6wcHajO01igVf2c8otUsGkdDpGBM45a7-oUKfRg@mail.gmail.com>
archived-at: Thu, 16 Jun 2016 21:33:42 -0000


--Apple-Mail=_16FCC121-7615-4602-A283-9426A4D36A2D
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

Hi,

To achieve the performance boost you need to use Apache Ignite SQL =
engine [1]. However all the data has to be located in caches (RAM). SQL =
engine doesn=E2=80=99t work against RDBMS.

So you need to preload data into caches from RDBMS using one of existed =
approaches [2]. After that you can start using Ignite SQL.
If you want to sync up caches with RDBMS then you need to use one of =
CacheStore interface implementations [3].

Finally, I would recommend you taking look at Ignite examples to see how =
the product works in practice.

[1] https://apacheignite.readme.io/docs/sql-queries =
<https://apacheignite.readme.io/docs/sql-queries>
[2] https://apacheignite.readme.io/docs/data-loading =
<https://apacheignite.readme.io/docs/data-loading>
[3] https://apacheignite.readme.io/docs/persistent-store

=E2=80=94
Denis

> On Jun 17, 2016, at 12:20 AM, Andr=C3=A9s Ivaldi <iaivaldi@gmail.com> =
wrote:
>=20
> Hello, I'm new with Apache Ignite, I'd like to know how can I use =
Apache Ignite cache to bust up RDBMS queries. I saw it in apache conn =
that is possible perform querys against RDBMS allowing to speed up it's =
execution
>=20
> Regards.
>=20
> --=20
> Ing. Ivaldi Andres


--Apple-Mail=_16FCC121-7615-4602-A283-9426A4D36A2D
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dutf-8"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" =
class=3D"">Hi,<div class=3D""><br class=3D""></div><div class=3D"">To =
achieve the performance boost you need to use Apache Ignite SQL engine =
[1]. However all the data has to be located in caches (RAM). SQL engine =
doesn=E2=80=99t work against RDBMS.</div><div class=3D""><br =
class=3D""></div><div class=3D"">So you need to preload data into caches =
from RDBMS using one of existed approaches [2]. After that you can start =
using Ignite SQL.</div><div class=3D"">If you want to sync up caches =
with RDBMS then you need to use one of CacheStore interface =
implementations [3].</div><div class=3D""><br class=3D""></div><div =
class=3D"">Finally, I would recommend you taking look at Ignite examples =
to see how the product works in practice.</div><div class=3D""><br =
class=3D""></div><div class=3D"">[1]&nbsp;<a =
href=3D"https://apacheignite.readme.io/docs/sql-queries" =
class=3D"">https://apacheignite.readme.io/docs/sql-queries</a></div><div =
class=3D"">[2]&nbsp;<a =
href=3D"https://apacheignite.readme.io/docs/data-loading" =
class=3D"">https://apacheignite.readme.io/docs/data-loading</a></div><div =
class=3D"">[3]&nbsp;<a =
href=3D"https://apacheignite.readme.io/docs/persistent-store" =
class=3D"">https://apacheignite.readme.io/docs/persistent-store</a></div><=
div class=3D""><br class=3D""></div><div class=3D"">=E2=80=94</div><div =
class=3D"">Denis</div><div class=3D""><br class=3D""><div><blockquote =
type=3D"cite" class=3D""><div class=3D"">On Jun 17, 2016, at 12:20 AM, =
Andr=C3=A9s Ivaldi &lt;<a href=3D"mailto:iaivaldi@gmail.com" =
class=3D"">iaivaldi@gmail.com</a>&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div class=3D""><div dir=3D"ltr" =
class=3D""><div class=3D"gmail_extra"><div class=3D"gmail_quote">Hello, =
I'm new with Apache Ignite, I'd like to know how can I use Apache Ignite =
cache to bust up RDBMS queries. I saw it in apache conn that is possible =
perform querys against RDBMS allowing to speed up it's execution<div =
class=3D""><br class=3D""></div><div class=3D"">Regards.<span =
class=3D""><font color=3D"#888888" class=3D""><br clear=3D"all" =
class=3D""></font></span></div><div class=3D""><br =
class=3D""></div></div>-- <br class=3D""><div class=3D"gmail_signature" =
data-smartmail=3D"gmail_signature">Ing. Ivaldi Andres<br class=3D""></div>=

</div></div>
</div></blockquote></div><br class=3D""></div></body></html>=

--Apple-Mail=_16FCC121-7615-4602-A283-9426A4D36A2D--