search

google-code-export / sqljet

Automatically exported from code.google.com/p/sqljet
0 stars 1 forks source link

Optimize performance #103

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Optimize performance

Original issue reported on code.google.com by sergey.s...@gmail.com on 15 Aug 2009 at 3:53

GoogleCodeExporter commented 9 years ago 
I've optimized reading of fields values.

Original comment by sergey.s...@gmail.com on 15 Aug 2009 at 4:47

GoogleCodeExporter commented 9 years ago 
Committed revision 535. (trunk)

Original comment by sergey.s...@gmail.com on 15 Aug 2009 at 4:48

GoogleCodeExporter commented 9 years ago 
After this optimization SQLJet is at least as twice faster than SQLite-NestedVM 
at
reading operation's benchmark.

Original comment by sergey.s...@gmail.com on 15 Aug 2009 at 4:53

GoogleCodeExporter commented 9 years ago 
for Java 1.5

benchmarks:
    [junit] Testsuite: org.tmatesoft.sqljet.benchmarks.SqlJetBenchmark
    [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 14,876 sec
    [junit] Testcase: nothing took 0,552 sec
    [junit] Testcase: updateAll took 3,054 sec
    [junit] Testcase: deleteAll took 0,72 sec
    [junit] Testcase: insertRandoms took 3,243 sec
    [junit] Testcase: clear took 0,328 sec
    [junit] Testcase: locate took 6,05 sec
    [junit] Testcase: selectAll took 0,83 sec
    [junit] Testsuite: org.tmatesoft.sqljet.benchmarks.NestedVmBenchmark
    [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 39,864 sec
    [junit] Testcase: nothing took 1,667 sec
    [junit] Testcase: updateAll took 5,613 sec
    [junit] Testcase: deleteAll took 1,145 sec
    [junit] Testcase: insertRandoms took 5,337 sec
    [junit] Testcase: clear took 0,624 sec
    [junit] Testcase: locate took 22,221 sec
    [junit] Testcase: selectAll took 3,155 sec

Original comment by sergey.s...@gmail.com on 4 Sep 2009 at 5:41

GoogleCodeExporter commented 9 years ago 
for Java 1.6

benchmarks:
    [junit] Testsuite: org.tmatesoft.sqljet.benchmarks.SqlJetBenchmark
    [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 9,713 sec
    [junit] Testcase: nothing took 0,344 sec
    [junit] Testcase: updateAll took 2,016 sec
    [junit] Testcase: deleteAll took 0,456 sec
    [junit] Testcase: insertRandoms took 2,333 sec
    [junit] Testcase: clear took 0,192 sec
    [junit] Testcase: locate took 3,767 sec
    [junit] Testcase: selectAll took 0,526 sec
    [junit] Testsuite: org.tmatesoft.sqljet.benchmarks.NestedVmBenchmark
    [junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 35,539 sec
    [junit] Testcase: nothing took 1,476 sec
    [junit] Testcase: updateAll took 3,618 sec
    [junit] Testcase: deleteAll took 0,984 sec
    [junit] Testcase: insertRandoms took 4,477 sec
    [junit] Testcase: clear took 0,577 sec
    [junit] Testcase: locate took 21,378 sec
    [junit] Testcase: selectAll took 2,945 sec

Original comment by sergey.s...@gmail.com on 4 Sep 2009 at 5:47

GoogleCodeExporter commented 9 years ago

Original comment by sergey.s...@gmail.com on 4 Sep 2009 at 5:48