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
|