search

JuliaDatabases / JDBC.jl

Julia interface to Java database drivers
Other
38 stars 19 forks source link

Using the Tables.jl interface is slow #61

Open aviks opened 2 years ago

aviks commented 2 years ago

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