General SQL Parser benchmark
The benchmark of General SQL Parser Java version using the single thread mode and multi-thread mode. General SQL Parser is not guaranteed to be thread safe, so you need to create a new instance of General SQL Parser in each thread.
Machine: Win 10, Intel(R) Core(TM) i5-4590 CPU @ 3.30GHz, 32G memory.
Software: JDK1.8, General SQL Parser Java version 2.3.6.5
Result of General SQL Parser Java version
=======================Benchmark 1k size file=============================================
Main thread: load sql parser 1.029 seconds
Parsing query of size 1k, repeated 100 times,...
Main thread: Takes 0.014 seconds to parse query of 1k, Total times: 1.432 seconds for query of 1k, repeated 100 times,.
Multi thread mode:
Thread 4, parse query of size 1k, takes 0.002 seconds, repeated in 100 times, takes 0.204 seconds
Thread 2, parse query of size 1k, takes 0.002 seconds, repeated in 100 times, takes 0.214 seconds
Thread 3, parse query of size 1k, takes 0.003 seconds, repeated in 100 times, takes 0.279 seconds
Thread 1, parse query of size 1k, takes 0.003 seconds, repeated in 100 times, takes 0.283 seconds
Thread 5, parse query of size 1k, takes 0.003 seconds, repeated in 100 times, takes 0.306 seconds
=======================Benchmark 10k size file=============================================
Main thread: load sql parser 0.000 seconds
Parsing query of size 11k, repeated 100 times,...
Main thread: Takes 0.009 seconds to parse query of 11k, Total times: 0.856 seconds for query of 11k, repeated 100 times,.
Multi thread mode:
Thread 2, parse query of size 11k, takes 0.011 seconds, repeated in 100 times, takes 1.070 seconds
Thread 1, parse query of size 11k, takes 0.011 seconds, repeated in 100 times, takes 1.095 seconds
Thread 4, parse query of size 11k, takes 0.011 seconds, repeated in 100 times, takes 1.055 seconds
Thread 5, parse query of size 11k, takes 0.010 seconds, repeated in 100 times, takes 1.022 seconds
Thread 3, parse query of size 11k, takes 0.012 seconds, repeated in 100 times, takes 1.155 seconds
=======================Benchmark 100k size file=============================================
Main thread: load sql parser 0.000 seconds
Parsing query of size 100k, repeated 100 times,...
Main thread: Takes 0.028 seconds to parse query of 100k, Total times: 2.841 seconds for query of 100k, repeated 100 times,.
Multi thread mode:
Thread 4, parse query of size 100k, takes 0.036 seconds, repeated in 100 times, takes 3.622 seconds
Thread 5, parse query of size 100k, takes 0.036 seconds, repeated in 100 times, takes 3.641 seconds
Thread 1, parse query of size 100k, takes 0.036 seconds, repeated in 100 times, takes 3.644 seconds
Thread 2, parse query of size 100k, takes 0.037 seconds, repeated in 100 times, takes 3.669 seconds
Thread 3, parse query of size 100k, takes 0.037 seconds, repeated in 100 times, takes 3.684 seconds