Bill Oliver wrote:

> Hello,
>
> I would like to time some queries for performance testing. I know I
> can do this in ISQL by using the SET STATS ON ; command. But, my co-
> worker has provided some queries that display a large result set. Is
> there some way to turn off display of the result set to the console?
>
> I'm not really interested in timing how fast my console can print the
> records. :)
>
> Perhaps there is a better technique that readers can provide? For some
> of the queries I can limit the rows returned by using ROWS 1, but this
> isn't always helpful. True, too, that a real world application would
> attempt to limit the number of rows returned to only those that are
> useful.
>
> -bill
>

Bill,

If you change de field list by count(*) could help ?

All records must be read by the server, but no network traffic or big
result set printed out.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br