|
-
It depend on what your Java does with your text file.
You can find out time taken for inserting operation and time taken for creating SQL statement. When you run Java there is default autocommit after each statement. And you read line by line your text file, so most probably problem is in I/O operations.
I made SQL package which generate 'insert' statement for entire schema, the size of schema is around 600Mb, but it runs already for 3-4 weeks, weak place in my case is I/O, but I am not in a hurry.
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|