Re: [Squirrel-sql-develop] display ony SQL time taken to retrieve info but not display data

On Mon, 9 Dec 2013, Ema...@rb... wrote:

>   I run some simple Select queries against my datasources. Some of the
>   queries return too much data but as I am working on performance tuning
>   I am only interested in the time that it took to retrieve all rows and
>   not in the data itself.
>
>   So I would like to know if it is possible to get only the time taken
>   to return all the rows from a SQL query against my datasources without
>   bringing back any data??
>
>   Any ideas would be a great help - either with a command to be added in
>   my SQL Select statement or just pointing where in the SQuirreL java
>   code I could change to dispose the data.

There are options to query the data to a file (I don't know the details 
because I've never used Squirrel to do that, sorry).

How about: use that option and enter the filename "/dev/null" for *nix or 
"nul:" for Windows.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
  6 days until Bill of Rights day