Hello! JDBC with SET STREAMING ON should work reasonably well. You could also use CacheStore.
With .Net I guess you will have to stick to DataStreamer & learn how to integrate it with Indexing properly. Or use JDBC from .Net. Regards, -- Ilya Kasnacheev чт, 7 мар. 2019 г. в 16:31, Mike Needham <[email protected]>: > Is that the most efficient way to load millions of rows from a database > table into a cache? I guess I am not seeing how this would work for > millions of rows in the source database. That also appears to be a JAVA > only solution and it would be preferable to have it be usable for .NET as > well as java and hopefully python. > > On Thu, Mar 7, 2019 at 6:55 AM Ilya Kasnacheev <[email protected]> > wrote: > >> Hello! >> >> What prevents you from reading rows from DB and feeding them to JDBC >> prepared statement? >> >> Regards, >> -- >> Ilya Kasnacheev >> >> >> чт, 7 мар. 2019 г. в 15:51, Mike Needham <[email protected]>: >> >>> And what if the data is already in a database table? I do not want to >>> read from the table to write to a file to load a cache. >>> >>> On Tue, Mar 5, 2019 at 4:06 AM Ilya Kasnacheev < >>> [email protected]> wrote: >>> >>>> Hello! >>>> >>>> The preferred approach is to use Thin JDBC client: >>>> https://apacheignite-sql.readme.io/docs/jdbc-driver >>>> >>>> Regards, >>>> -- >>>> Ilya Kasnacheev >>>> >>>> >>>> пн, 4 мар. 2019 г. в 19:39, Mike Needham <[email protected]>: >>>> >>>>> Thanks for the links, If SET STREAMING ON is the preferred method, >>>>> how would you do this in code rather than from a file with all the insert >>>>> statements. >>>>> >>>>> On Mon, Mar 4, 2019 at 1:44 AM Ilya Kasnacheev < >>>>> [email protected]> wrote: >>>>> >>>>>> Hello! >>>>>> >>>>>> You can see at this page: >>>>>> https://apacheignite-sql.readme.io/docs/sql-and-key-value-usage >>>>>> >>>>>> And then substitite cache.put() with addData() and cache name will be >>>>>> SQL_PUBLIC_{table name in caps} >>>>>> >>>>>> There are not many examples since this is being discouraged in favor >>>>>> of SET STREAMING ON, actually: >>>>>> https://apacheignite-sql.readme.io/docs/set >>>>>> >>>>>> Regards, >>>>>> -- >>>>>> Ilya Kasnacheev >>>>>> >>>>>> >>>>>> пт, 1 мар. 2019 г. в 22:48, Mike Needham <[email protected]>: >>>>>> >>>>>>> I have looked at the documentation and the code samples and nothing >>>>>>> is doing what I am trying to do. I want to be able to use the >>>>>>> datastreamer >>>>>>> to load 3 or 4 TABLES in a cache for an application that we use. If I >>>>>>> create the tables using a create table syntax how do attach a >>>>>>> datastreamer >>>>>>> to the different caches if the cache name is PUBLIC for all of them? >>>>>>> >>>>>>> On Thu, Feb 28, 2019 at 8:13 AM Ilya Kasnacheev < >>>>>>> [email protected]> wrote: >>>>>>> >>>>>>>> Hello! >>>>>>>> >>>>>>>> I have linked the documentation page, there are also some code >>>>>>>> examples in distribution. >>>>>>>> >>>>>>>> Regards, >>>>>>>> -- >>>>>>>> Ilya Kasnacheev >>>>>>>> >>>>>>>> >>>>>>>> чт, 28 февр. 2019 г. в 17:10, Mike Needham <[email protected]>: >>>>>>>> >>>>>>>>> Is there any examples that show the steps to do this correctly? I >>>>>>>>> stumbled upon this but have no idea if it is the best way to do this >>>>>>>>> >>>>>>>>> On Thu, Feb 28, 2019 at 6:27 AM Ilya Kasnacheev < >>>>>>>>> [email protected]> wrote: >>>>>>>>> >>>>>>>>>> Hello! >>>>>>>>>> >>>>>>>>>> There's no restriction on cache name but setting it up for the >>>>>>>>>> first time may be tricky indeed. >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> -- >>>>>>>>>> Ilya Kasnacheev >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> ср, 27 февр. 2019 г. в 19:48, needbrew99 <[email protected]>: >>>>>>>>>> >>>>>>>>>>> OK, was able to get it working. Apparently the cache name has >>>>>>>>>>> to be PUBLIC >>>>>>>>>>> and it will create a table based on the object definition that I >>>>>>>>>>> have. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> *Some days it just not worth chewing through the restraints* >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Some days it just not worth chewing through the restraints* >>>>>>> >>>>>> >>>>> >>>>> -- >>>>> *Some days it just not worth chewing through the restraints* >>>>> >>>> >>> >>> -- >>> *Some days it just not worth chewing through the restraints* >>> >> > > -- > *Some days it just not worth chewing through the restraints* >
