> Just run this query and show us results:
>
> SELECT R.RDB$RELATION_NAME, COUNT(*)
> FROM RDB$PAGES PG JOIN RDB$RELATIONS R
> ON PG.RDB$RELATION_ID = R.RDB$RELATION_ID
> WHERE PG.RDB$PAGE_TYPE = 4
> AND R.RDB$RELATION_NAME IN ('DESC_VARCHAR', 'DESC_EMPTY')
> GROUP BY R.RDB$RELATION_NAME
DESC_BLOB: 1872
DESC_EMPTY: 135
DESC_VARCHAR: 2166
> Also, could you repeat the test using bigger page cache, say > 1200 pages ?
With page buffer to 1200 pages, nothing change too much, but with a buffer of
around 3000 page yes stat become to be better (but not for the first select, we
need to do several select to see the speed go down, i thing the time to read
the page from disk to the cache)
with 1200 pages buffer => 23 ms / select
with 3000 pages buffer => 10 ms / select (so 2x more faster)
the problem with superclassic architecture not so easy to increase the page
buffer without taking the risk to use an huge amount of memory during peak
activity time
select
IDObj
From
desc_varchar
where
IDObj='NOT_EXIST'
********************************
1rt select
PREPARE :
Time Taken: 31 ms
page_reads: 2182
page_writes: 0
page_fetches: 2287
page_marks: 0
record_idx_reads: 20
record_seq_reads: 0
EXECUTE :
Time Taken: 0 ms
page_reads: 4
page_writes: 0
page_fetches: 4
page_marks: 0
record_idx_reads: 0
record_seq_reads: 0
********************************
2nd time
PREPARE :
Time Taken: 16 ms
page_reads: 0
page_writes: 0
page_fetches: 2169
page_marks: 0
record_idx_reads: 0
record_seq_reads: 0
select
Time Taken: 0 ms
page_reads: 0
page_writes: 0
page_fetches: 4
page_marks: 0
record_idx_reads: 0
record_seq_reads: 0
