Subject Re: [firebird-support] Help with timing queries
Author Alexandre Benson Smith
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

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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil