Thanks Ilya. Will try using together.
Please correct if the below statement work.
getConnection().createStatement().execute("SET STREAMING ON");
Regards,
Sriveena
From: Ilya Kasnacheev [mailto:[email protected]]
Sent: Thursday, September 06, 2018 3:28 PM
To: [email protected]
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
<[email protected]<mailto:[email protected]>>:
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]<mailto:[email protected]>]
Sent: Wednesday, September 05, 2018 7:02 PM
To: [email protected]<mailto:[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.”
“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.”
