JRuby and JDBC ResultSet in Sqlite3


#1

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


#2

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


#3

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


#4

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