Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

handlersocket bulk insert is much slower than via jdbc driver #8

Open
lablz opened this issue Oct 7, 2012 · 2 comments
Open

handlersocket bulk insert is much slower than via jdbc driver #8

lablz opened this issue Oct 7, 2012 · 2 comments

Comments

@lablz
Copy link

lablz commented Oct 7, 2012

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?
@killme2008
Copy link
Owner

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

@lablz
Copy link
Author

lablz commented Oct 8, 2012

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@killme2008 @lablz