Since we talk l2j heres what i would do...
Switch from c3p0 to BoneCP, look at these http://jolbox.com/index.html?page=http://jolbox.com/benchmarks.html
Use onboot table optimalization.
Proper configuration(lazy init, connection wrapper setup,caching).
And when thats done and you still need more, you can optimize the mysql server itself.