Hi Ilya, Can we cobimbe both of them together I mean
1. SET STREAMING ON; 2. JDBC thin driver batch insert (pstmt.executeBatch()) Thanks & Regards, Sriveena From: Ilya Kasnacheev [mailto:[email protected]] Sent: Wednesday, September 05, 2018 7:02 PM To: [email protected] 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&data=02%7C01%7CSriveena.Mattaparthi%40ekaplus.com%7C7d329f7496a845c707bb08d61333fb1d%7C2a5b4e9716be4be4b2d40f3fcb3d373c%7C1%7C0%7C636717511328312021&sdata=WfZ7m34afylAJv0PZ0GRo2o7mIQVxR6f%2BCb2MuQUj3M%3D&reserved=0> Regards, -- Ilya Kasnacheev ср, 5 сент. 2018 г. в 15:44, Sriveena Mattaparthi <[email protected]<mailto:[email protected]>>: Hi, I am trying to batch insert 300000 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 intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.” “Confidentiality Notice: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.”
