antipodes1
Active Member
I know that the tech flash is about a month old, but has nayone implemented this and seen significant performance change?
TECHFLASH GSSTF-02-0462
Title: SQL Server Cursor Types / SQL Server Database Performance
Topic: This announcement relates to all implementations of OneWorld® accessing data stored in Microsoft SQL Server databases. A significant performance improvement can be realized by removing the “CursorType” entry in the OneWorld® server JDE.INI.
Release(s): This applies to customers with B733.1, B733.2, Xe and ERP 8.0.
Platform(s): OneWorld configurations which use SQL Server databases.
Issue: Database operations will execute faster if the cursor type is removed from server JDE.INI files. OneWorld® system code automatically chooses the SQL Server cursor type. Forcing a specific cursor type can degrade system performance.
This issue pertains to server-based JDE.INI files only. Microsoft® SQL Server releases 7.0 and 2000 can benefit from this change.
Typically, the CursorType= entry in the server JDE.INI file defaults to a value of 3. This value will utilize the static cursor type. Removing this entry from the server JDE.INI will cause the OneWorld® SQL Server database driver to use fast forward cursors with autofetch enabled.
Fix/Workaround: The fix is to remove the CusorType entry from [DB System Settings] in JDE.INI files for OneWorld® servers.
Antipodes
TECHFLASH GSSTF-02-0462
Title: SQL Server Cursor Types / SQL Server Database Performance
Topic: This announcement relates to all implementations of OneWorld® accessing data stored in Microsoft SQL Server databases. A significant performance improvement can be realized by removing the “CursorType” entry in the OneWorld® server JDE.INI.
Release(s): This applies to customers with B733.1, B733.2, Xe and ERP 8.0.
Platform(s): OneWorld configurations which use SQL Server databases.
Issue: Database operations will execute faster if the cursor type is removed from server JDE.INI files. OneWorld® system code automatically chooses the SQL Server cursor type. Forcing a specific cursor type can degrade system performance.
This issue pertains to server-based JDE.INI files only. Microsoft® SQL Server releases 7.0 and 2000 can benefit from this change.
Typically, the CursorType= entry in the server JDE.INI file defaults to a value of 3. This value will utilize the static cursor type. Removing this entry from the server JDE.INI will cause the OneWorld® SQL Server database driver to use fast forward cursors with autofetch enabled.
Fix/Workaround: The fix is to remove the CusorType entry from [DB System Settings] in JDE.INI files for OneWorld® servers.
Antipodes
