Using the Tables.jl interface is slow

[aviks]

Using the sqlite driver and the sample toursdb database, flights table (see package tests for details)

@time DataFrame(collect(JDBCRowIterator(rs)))
  0.100710 seconds (451.67 k allocations: 20.420 MiB)

@time JDBC.load(DataFrame, rs)
  0.770983 seconds (713.62 k allocations: 31.410 MiB, 2.18% gc time)

Some investigation has been reported upstream: https://github.com/JuliaData/Tables.jl/issues/265