Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# 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.

Download C# demo, Java demo