hs4j icon indicating copy to clipboard operation
hs4j copied to clipboard
verified publisher icon killme2008

handlersocket bulk insert is much slower than via jdbc driver

Open lablz opened this issue 13 years ago • 2 comments

Please see: http://philipzhong.blogspot.com/2011/06/performance-test-for-mysql-sql-and.html

May be I am missing something and bulk insert with HS4J is possible?

lablz avatar Oct 07 '12 20:10 lablz

What's your hsf4j client configuration? Did you use connection pool? Did you reuse IndexSession?

killme2008 avatar Oct 08 '12 02:10 killme2008

Sorry, I just reposted my find of this article. I could not find any info on how to turn on bulk/batch mode in HS4J. According to this article the batching inserts via j/connector was the key factor in making it several times faster than HS4J. What I am looking to achieve is to beat LOAD DATA INFILE with handlersocket, for that it must be several times faster than regular bulk inserts. Is it possible?

lablz avatar Oct 08 '12 07:10 lablz