create more than one thread to be run at the same time

Question

lena1990 -3

5 Years Ago

hi all
i want to create a program that each thread will be handle a part of the log file and read from it at the same time ??

Thanks in advance

java

2 Contributors
4 Replies
19 Views
5 Years Discussion Span
Latest Post 5 Years Ago by lena1990

JamesCherrill 3,702 · Answer 1 · 2013-09-25T09:27:23+00:00

Well, OK, you can do that. If this is a follow-on to you still unsolved "handling large files" topic then messing about with how you read the logs isn't going to make any real difference - it's the SQL that needs to be optimised. You may get the best throughput by having one thread reading the log and placing entries on a blocking queue, with one or more threads taking enries from the queue to update the database.
Maybe you can clarify exactly what you are trying to do, and exactly what help you need?

lena1990 -3 · Answer 2 · 2013-09-25T11:32:57+00:00

thanks for replay
i inserted one million row every 20 minutes so i think there is no problem with data base but if more than one process reads from the log and inserted to the database it will make it faster donot you think???

JamesCherrill 3,702 · Answer 3 · 2013-09-25T11:53:04+00:00

I'm goint to stick with what I suggested in my previous post. Have a single thread reading the log, and experiment to find the optimum number of threads updating the database. Have a look at the Oracle tutorial on Java Threads, and the API doc for LinkedBlockingQueue

lena1990 -3 · Answer 4 · 2013-09-25T12:41:00+00:00

i just want to see or try if it will make any difference in the number of records inserted iam still searching for the best solution