Re: [sqr-users] improving DB2 SQL select performance.

["Arnon Oppenheimer" <arnono@semech.co.il>]

Do you Print with SQR ?
Try run SQR with selects only, without Prints !!

BI just bring data to the PC Memory,
SQR does many IO while it print, and this makes the difference.

SQR/DB2 use CLI and it performance is perfect.

Arnon

----- Original Message ----- 
From: "Steve Cavill" <steve.cavill@infoclarity.com.au>
To: <sqr-users@sqrug.org>
Sent: Friday, February 20, 2004 10:46 PM
Subject: [sqr-users] improving DB2 SQL select performance.


> DB2 8.1 on Windows NT server
> SQR 8.1
>
> Can anyone recommend any "quick fixes" for DB2 select performance.  I am
> running SQR and Brio intelligence on the same box, using the same DB2
> connection, to a remote DB2 server, and Intelligence is running much
faster.
> I am basically running table scans against large databases - 4 million
rows.
>
> I added FOR FETCH ONLY to the end of my select which doubled the speed.
>  The -Bnnn option doesn't seem to work with DB2.  Is there a way to
increase
> the buffer size?
>
> I'll confess I know very little about DB2.  I know Brio Intelligence is
> using an ODBC connection.  Is SQR using the same connection or does it use
> CLI or something else?  I access DB2 using DB2 connect software.
>
> Any tips greatly appreciated.
>
> Thanks, Steve.
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users