> 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 SET,
Just for you my Friend... Please check...
CREATE TABLE BOOK_SELLING_DETAIL( BOOK_NO Integer, BOOK_ID Integer,
PUBLISHER Varchar(50), MAIN_BRACH Varchar(10), PUBLISH_DATE Date,
ORIGINAL_PRICE Float, SELLING_PRICE Float);
INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO, BOOK_ID,
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
> I have a problem about the database encryption in Firebird 3. I hope you can
> give me some solution or an email address where i can get advice. > I would
> like create an encryption DLL but my algorithm create bigger encrypted data
> size than the source data.
> As I see its not possible
> 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
Hi,
Is there a way to detect throught mon$ tables or trace or other way disk
operations caused by query? I see only page_reads and page_writes, page_marks,
page_fetches but how to distinguish which one:1. Page is read because missed in
cache2. Page is read/write beacause of big sort operation3.