Hi,
thank you Vlad for clarify
I have created ticket http://tracker.firebirdsql.org/browse/CORE-5577
regards,
Karol Bieniaszewski
From: hv...@users.sourceforge.net [firebird-support]
Sent: Thursday, July 6, 2017 12:05 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re
> 3. Page is read/write from temp object bigger then memory buffer e.g big
> global temporary table, others?
>> GTT's data go thru the common page cache as all other database operations.
What happen when GTT will be bigger then whole mem cache? It will go to disk?
If yes, how to catch such
Hi,
> 2. Page is read/write beacause of big sort operation
>> Sort IO is directed into separate temporary files and it is nor cached by
>> the engine, nor paged.
>> Unfortunately, engine doesn't collect Sort statistics.
Will be good to see this on trace output and accumulated stats on
> Is there a way to detect throught mon$ tables or trace or other way disk
> operations caused by query?
Engine collects some performance stats counters internally. Trace,
monitoring, ISC API - all query engine's
performance data. Therefore there is no "special hidden ways" to ask engine for
