General SQL Parser benchmark
This is a demo test performance of General SQL Parser using 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 XP SP3, Intel(R) Core(TM)2 Duo CPU E8400 @3.00GHz, 2G memory.
Software: .NET framework 2.0, JDK1.5
Result of General SQL Parser .NET version
Main thread, load sql parser: 0.38 seconds Main thread: parsing 50000 sqls ... Main thread: In 8.47 seconds, 5903.88 sql/second. Multi thread mode: Parse 10000 sqls in thread 2: 4.00 seconds Parse 10000 sqls in thread 4: 4.00 seconds Parse 10000 sqls in thread 3: 4.00 seconds Parse 10000 sqls in thread 5: 4.00 seconds Parse 10000 sqls in thread 1: 4.00 seconds Main thread: parsing 50000 sql in 4.53 seconds, 11035.09 sql/second.
Result of General SQL Parser Java version
Main thread: load sql parser 0.500 seconds Main thread: Parsing 50000 sqls,... Main thread: In 8.594 seconds, 5818.013 sql/second. Multi thread mode: Parse 10000 sqls in thread 1: 4.328 seconds Parse 10000 sqls in thread 2: 4.468 seconds Parse 10000 sqls in thread 4: 4.515 seconds Parse 10000 sqls in thread 5: 4.703 seconds Parse 10000 sqls in thread 3: 4.750 seconds Main thread: parsing 50000 sql in 4.750 seconds, 10526.316 sql/second.