brother_of_karamazov
Legendary Poster
Solution ID: 201030108
SOLUTION:
EnterpriseOne Tools Development has tested and evaluated the SQL Server 2005 JDBC driver running against SQL Server 2000 DB and the difference is dramatically faster. SQL Server 2005 JDBC driver utilizes fast forward cursors (similar to ODBC driver) and no longer downgrades to a less efficient cursor on the database connection. If receiving poor performance on Find/Browse application forms that access a table with 750K to 1 million plus records (e.g. transaction tables: F0911, F03B13, etc....), the recommendation is to upgrade to SQL Server 2005 JDBC driver.
Minimum Technical Requirements to utilize SQL Server 2005 JDBC driver are:
* EnterpriseOne 8.9 and above
* EnterpriseOne Tools release 8.96.D1
* Websphere 6.0
SOLUTION:
EnterpriseOne Tools Development has tested and evaluated the SQL Server 2005 JDBC driver running against SQL Server 2000 DB and the difference is dramatically faster. SQL Server 2005 JDBC driver utilizes fast forward cursors (similar to ODBC driver) and no longer downgrades to a less efficient cursor on the database connection. If receiving poor performance on Find/Browse application forms that access a table with 750K to 1 million plus records (e.g. transaction tables: F0911, F03B13, etc....), the recommendation is to upgrade to SQL Server 2005 JDBC driver.
Minimum Technical Requirements to utilize SQL Server 2005 JDBC driver are:
* EnterpriseOne 8.9 and above
* EnterpriseOne Tools release 8.96.D1
* Websphere 6.0