I am using jdbc to access database but suffer from performance problem.
Well, I think I can't boost the performance by modifying the code since the
resultset is quite large and maybe it is the JdbcDriver problem.
So I am now thinking of using multithread to traverse the resultset and
do the processing. Say thread 1 do processing on 1 to 100 records. Thread 2
go to 101 to 200 (maybe by going thru a cloned resultset). Can this boost
the performance ? Or is there other ways that I may use multithread? Since
my server has 4 cpu. So it is quite advantageous if I could use multithread.
Is there anything I need to be aware of ? Is there any article or example
source on that ?
It seems that I seldom heard ppl using this. So I am not sure if this