Re: Batch insert into ignite using jdbc thin driver taking long time

eateStatement().execute("SET STREAMING ON"); > > > > Regards, > > Sriveena > > > > *From:* Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com] > *Sent:* Thursday, September 06, 2018 3:28 PM > *To:* user@ignite.apache.org > *Subject:* Re: Batch insert

Re: Batch insert into ignite using jdbc thin driver taking long time

user@ignite.apache.org Subject: Re: Batch insert into ignite using jdbc thin driver taking long time Hello! I'm not sure but it doesn't look right to me. Does it compile? Note that you also need to SET STREAMING OFF after data load is complete. -- Ilya Kasnacheev чт, 6 сент. 2018 г. в 1

Re: Batch insert into ignite using jdbc thin driver taking long time

> *Sent:* Thursday, September 06, 2018 3:28 PM > *To:* user@ignite.apache.org > *Subject:* Re: Batch insert into ignite using jdbc thin driver taking > long time > > > > Hello! > > > > I don't see why not. Have you tried? Any difference in run time? > >

RE: Batch insert into ignite using jdbc thin driver taking long time

apache.org Subject: Re: Batch insert into ignite using jdbc thin driver taking long time Hello! I don't see why not. Have you tried? Any difference in run time? Regards, -- Ilya Kasnacheev чт, 6 сент. 2018 г. в 6:20, Sriveena Mattaparthi mailto:sriveena.mattapar...@ekaplus.com>>: Hi Ilya,

Re: Batch insert into ignite using jdbc thin driver taking long time

STREAMING ON; > > 2. JDBC thin driver batch insert (pstmt.executeBatch()) > > > > Thanks & Regards, > Sriveena > > > > *From:* Ilya Kasnacheev [mailto:ilya.kasnach...@gmail.com] > *Sent:* Wednesday, September 05, 2018 7:02 PM > *To:* user@ignite.

RE: Batch insert into ignite using jdbc thin driver taking long time

.org Subject: Re: Batch insert into ignite using jdbc thin driver taking long time Hello! Have you tried streaming mode? https://apacheignite-sql.readme.io/docs/set<https://apac01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fapacheignite-sql.readme.io%2Fdocs%2Fset&d

Re: Batch insert into ignite using jdbc thin driver taking long time

Hello! Have you tried streaming mode? https://apacheignite-sql.readme.io/docs/set Regards, -- Ilya Kasnacheev ср, 5 сент. 2018 г. в 15:44, Sriveena Mattaparthi < sriveena.mattapar...@ekaplus.com>: > Hi, > > > > I am trying to batch insert 30 records into ignite cache(on remote > server)

Batch insert into ignite using jdbc thin driver taking long time

Hi, I am trying to batch insert 30 records into ignite cache(on remote server) using jdbc thin driver. It is taking nearly 4mins to complete this operation. Please advise. Thanks & Regards, Sriveena "Confidentiality Notice: The contents of this email message and any attachments are intende

RE: Batch insert into ignite

driver. But we would want to add the data stream into insert table. Is this possible? Regards, Sriveena From: Michael Cherkasov [mailto:michael.cherka...@gmail.com] Sent: Wednesday, July 25, 2018 6:23 PM To: user@ignite.apache.org Subject: Re: Batch insert into ignite Hi again, One more option as

Re: Batch insert into ignite

t:* Tuesday, July 24, 2018 9:49 PM > > *To:* user@ignite.apache.org > *Subject:* Re: Batch insert into ignite > > > > I can't say for sure which one should be better for sure, it must be > benchmarked. > > But if you can use SqlFieldsQuery this means that you can

RE: Batch insert into ignite

Thanks for the clarification Michael..will try the streamer option. Regards, Sriveena From: Michael Cherkasov [mailto:michael.cherka...@gmail.com] Sent: Tuesday, July 24, 2018 9:49 PM To: user@ignite.apache.org Subject: Re: Batch insert into ignite I can't say for sure which one shou

Re: Batch insert into ignite

which one would perform better > 1. Insert using IgniteJdbcDriver > 2. Insert using SqlFieldsQuery > > Thanks & Regards, > Sriveena > > -Original Message- > From: Mikhail [mailto:michael.cherka...@gmail.com] > Sent: Monday, July 23, 2018 10:32 PM > To: user@ignit

RE: Batch insert into ignite

-Original Message- From: Mikhail [mailto:michael.cherka...@gmail.com] Sent: Monday, July 23, 2018 10:32 PM To: user@ignite.apache.org Subject: Re: Batch insert into ignite Hi Sriveena, for data load you can try to use streaming mode for jdbc: https://apac01.safelinks.protection.outlook.

RE: Batch insert into ignite

Thanks Mikhail...will try the same and get back to you.. -Original Message- From: Mikhail [mailto:michael.cherka...@gmail.com] Sent: Monday, July 23, 2018 10:32 PM To: user@ignite.apache.org Subject: Re: Batch insert into ignite Hi Sriveena, for data load you can try to use streaming

Re: Batch insert into ignite

Hi Sriveena, for data load you can try to use streaming mode for jdbc: https://apacheignite.readme.io/docs/jdbc-driver#section-streaming-mode it will provide faster insert operation compare to regular insert, also you can disable WAL: https://apacheignite.readme.io/docs/write-ahead-log#section-wal

Batch insert into ignite

Hi, How can we perform batch insert/update into ignite tables (created through sqlquery fields as create table)? Thanks & Regards, Sriveena