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

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Hi Arnon,
Thanks for the reply
I was not doing any printing, just begin-select with no prints. (simply to
test performance)
Still was a lot slower until a used "for fetch only" on the select.
Now still a bit slower - I assume there are some CLI parameters I can tweak
but I don't know what they are.
Steve.

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Arnon Oppenheimer
Sent: Thursday, 26 February 2004 4:53 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] improving DB2 SQL select performance.


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

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