ActiveRecord-JDBC adapter for Derby/JavaDB does not support database level
LIMITs or OFFSETs
--------------------------------------------------------------------------------------------
Key: JRUBY-3624
URL: http://jira.codehaus.org/browse/JRUBY-3624
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Environment: OSX Leopard using Java 1.5
Reporter: Christopher Saunders
Derby 1.5.1.1 now supports FETCH and OFFSET and calling :limit or :offset from
ActiveRecord does not send the SQL off to the database. Instead ActiveRecord
simply sends a SELECT statement then appears to limit or offset the results in
memory.
When the data sets get quite large this leads to an obvious drop in performance.
Other adapters such as jdbc_mysql support LIMIT and OFFSET
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
