[Louis] Also, if I remove the order by, IP reports a drastic reduction is
execution time i.e. down to 6msec. Does the ORDER BY on the PK make
such a
difference?
[Set]My guess would rather be that the ORDER BY forces Fb to fetch all rows,
whereas without ORDER BY only the first few (random)
[mailto:firebird-support@yahoogroups.com]
Sent: 11 August 2015 06:15 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Reads inconsistency between FB TraceManager
and IB Planalyser
Hi Lois,
Reads value means actual reads from the disk.
If you run query twice, necessary
Sure I understand that, but the reads/fetches are 3000 to return 1 row.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: 11 August 2015 06:15 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Reads inconsistency between FB
-support@yahoogroups.com]
Sent: 11 August 2015 06:49 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Reads inconsistency between FB TraceManager
and IB Planalyser
On Aug 11, 2015, at 12:22 PM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] firebird-support
On Aug 11, 2015, at 1:30 PM, 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support] firebird-support@yahoogroups.com wrote:
Thanks Ann, so maybe the 2 tools' metric are different. So maybe FBTM
includes all (low level) reads and IP only user table reads.
Or maybe one runs some queries
Also, if I remove the order by, IP reports a drastic reduction is
execution time i.e. down to 6msec. Does the ORDER BY on the PK make
such a
difference?
Unh, maybe. Between the list, my mail system and yours, I've lost
most of the formatting and can't look at the original while typing