Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Problem - Slow over network

Help
Nora
2013-04-08
2013-05-15
  • Nora
    Nora
    2013-04-08

    When I use URL jdbc:csql everything is fast
    Connection connect = DriverManager.getConnection("jdbc:csql", "root", "manager");

    When I use URL jdbc:csql://localhost:5678/csql everything is very slow
    Connection connect = DriverManager.getConnection("jdbc:csql://localhost:5678/csql", "root", "manager");

    this is the time for 1000 selects and inserts in milliseconds (same example with different url string)
    jdbc:csql
    Insert: 166
    Select:2

    jdbc:csql://localhost:5678/csql
    Insert:40292
    Select:40000

    What am I doing wrong?