RE: [sqr-users] Migration SQR 2.5 to 6.2 for Oracle in HP

[Franck Masson <Franck.Masson@brio.com>]

To increase the performance of your select use the option -Bxxx on the
begin-select statement or on the command line


BEGIN-SELECT  [ DISTINCT ]  [ -Cnn ]  [ -Bnn ]  [ -XP] [ -NR ]  [ -SORTnn ] 
[ -LOCK { RR | CS | RO | RL | XX } ] [ -DBdatabase ] [ -DBconnection string
] 
[ LOOPS = nn ]  [ ON-ERROR = procedure  [ ( arg1 [, argi ] ... ) ] ]
END-SELECT
-Bnn - (ODBC, Oracle, SYBASE CT-Lib) Sets the number of rows to retrieve at
one time. This is for performance purposes only. Regardless of this setting,
all rows will be selected. The default, without using -B, is 10 rows. An
overall setting for a program can be indicated on the SQR command line with
-B, which can be overridden by a separate -B flag on each BEGIN-SELECT
command.

or

SQR report.sqr -B1000



-----Original Message-----
From: Juan Alvarado [mailto:juan@gyssa.com]
Sent: lundi 11 août 2003 16:26
To: sqr-users@sqrug.org; sqr-users@sqrug.org
Subject: RE: [sqr-users] Migration SQR 2.5 to 6.2 for Oracle in HP


The database is Oracle 8.x, and the reports do select, insert and
deletes....

________________________________

From: sqr-users-admin@sqrug.org on behalf of Franck Masson
Sent: Fri 8/8/2003 4:33 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Migration SQR 2.5 to 6.2 for Oracle in HP



what is your database ?
and what is doing your report ( only select or insert/update)


-----Original Message-----
From: Juan Alvarado [mailto:juan@gyssa.com]
Sent: samedi 9 août 2003 00:13
To: sqr-users@sqrug.org
Subject: [sqr-users] Migration SQR 2.5 to 6.2 for Oracle in HP


I already migrate the reports form sqr version 2.5 to sqr version 6.2 in
HP/UX.  But I saw a slow performance in about 50% of the reports.  For
example I have an SQR that take 5 minutes in 2.5 and now in 6.2 take 1
hour to complete...

What can I look for resolve this issue??  Anyone have similar
experience??

Thanks

Juan Alvarado

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003


_______________________________________________
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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003
 

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