JRuby and JDBC ResultSet in Sqlite3

Someone know why resultset.next() is so slow in jruby?
i mean i tried to make a simple query (4 rows) directly by a jdbc sql
query, because ActiveRecord took 3,5secs to do, well the executequery is
pretty fast (less than a sec), but the calls to resultSet.next method
rise the total time to 3,8secs!

there is some tips to suggest?

Thanks
Wladjmir

also only iterate (without do nothing with values) in a resultset of
200’000 took 200secs!
too much i think

sorry, the driver is not for sqlite3 but sequelink for filemaker

Wladjmir W. wrote:

sorry, the driver is not for sqlite3 but sequelink for filemaker

Wladjmir,
Can you give me the correct way to use the sequelink driver for
filemaker? I’m attempting to communicate with my server, and am not
able to do so properly.
Could you post the db config and possible model configurations?
Thanks

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs