Cursor type for SQL2005

Hi,
the jde.ini at a client (XE, SP23, sql2005 with hot fix applied) is set to is set to have CursorType=3 e.g. static cursors. They are having really poor performance from batches...

Static cursors I understand are the worst sort - can I delete this line in the server ini or change this to a type 6 (fast forward) and what might the issues be ??

Cheers

Peter

I thought that static cursr

Yep, absolutely! - this was a documented "recommended change" in some SP installation doc...

Hi ALex,
long time no speak!

You dont happen to know the specifics do you?

Or the document if you have it around

Cheers

Peter

Nope, too old - this was some 5 years ago...

Oh

Can anyone post the DB settings they use in an XE environment?

This is the one I am working with:
[DB SYSTEM SETTINGS]
Version=43
ODBCCursors=1
CursorType=3
Default User=JDE
Default Pwd=********
Default Env=PD7333
Default PathCode=PD7333
Base Datasource=ANIMAL - B7333 Server Map
Object Owner=SVM7333
Server=ANIMAL
Database=ANIMAL - B7333 Server Map
Load Library=JDBODBC.DLL
Decimal Shift=Y
Julian Dates=Y
Use Owner=Y
Secured=Y
Type=S
Library List=

It would be really appreciated!

Best regards

Peter

Just remove:

ODBCCursors=1
CursorType=3

(keep the "Version=43", it must be kept there!)