Jdbc_static performance issues

Hello there,

I am comparing Jdbc_static performance to Jdbc_streaming performance. I expected to see that Jdbc_static is slower for the first few event but scales better the more events use that filter. Oddly Jdbc_streaming is faster no matter the number of events.
Of course the database server the plugins connect to has faster hardware than my local computer, but the difference is not that big.
Any ideas where to look at?

The local JVM heap size is set to 2g which should be enough for the 500 records I am talking about.

Here is the jdbc_static config:

filter {
  jdbc_static {
    jdbc_driver_library => "mssql-jdbc-7.0.0.jre8.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver://…"
    loaders => [{
      query => "select ID, NAME from TABLE"
      local_table => "TEST"
    }]
    local_db_objects => [{
      name => "TEST"
      index_columns => [ "ID" ]
      columns => [
        [ "ID", "numeric(12)" ],
        [ "NAME", "varchar(255)" ]
      ]
    }]
    local_lookups => [{
      query => "select ID, NAME from TABLE where ID = :id"
      parameters => { "id" => "[id]" }
      target => "[@metadata][foo]"
    }]
  }
}

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.