If you are using Oracle or Sybase, there is the -B command that you can use on your BEGIN-SELECT line to increase the number of row returned at one time to SQR. The default is 10, and I have made big performance increases on buffering 100 rows vs. 10. Should definitely help in your case.
......Rob
----------------------------------------------------------------------------
Robert Goshko | Axis Developments | System Consulting Services
robert.goshko@axis-dev.com | Sherwood Park, AB | http://www.axis-dev.com/
-----Original Message-----
From: Moore Anthony [SMTP:Anthony_Moore@BSCC.BLS.COM]
Sent: Monday, July 13, 1998 8:57 AM
To: Multiple recipients of list SQR-USERS
Subject: Data warehousing
Are there any SQR users working with the RED BRICK database or similar
databases DESIGNED for data warehousing? I'm looking for SQR
performance tips relating specifically for large scale retrievals (100
million rows).
Unrecognized Data: application/ms-tnef