Subject | RE: [firebird-support] Re: Speed issues |
---|---|
Author | |
Post date | 2015-02-08T07:09:21Z |
after full restore of the database, now with 8192 page size, i got
Query
------------------------------------------------
select distinct
articles.art_id,
articles.art_article_nr,
generic_articles.ga_id,
link_art.la_id,
link_la_typ.lat_sort sort,
link_la_typ.lat_sup_id bra_id,
articles.art_replacement
from link_la_typ
inner join generic_articles on lat_ga_id = ga_id
inner join link_art on lat_la_id = la_id
inner join articles on la_art_id = art_id
where link_la_typ.lat_typ_id=:TYP_ID and link_la_typ.lat_ga_id=:GA_ID
ORDER BY 7 ASC
, 2 ASC
Plan
------------------------------------------------
PLAN SORT (SORT (JOIN (GENERIC_ARTICLES INDEX (GENERIC_ARTICLES_IDX1), LINK_LA_TYP INDEX (LINK_LA_TYP_IDX5), LINK_ART INDEX (LINK_ART_IDX1), ARTICLES INDEX (ARTICLES_IDX1))))
Query Time
------------------------------------------------
Prepare : 16.00 ms
Execute : 3,588.00 ms
Avg fetch time: 170.86 ms
Memory
------------------------------------------------
Current: 18,391,304
Max : 18,452,704
Buffers: 2,048
Operations
------------------------------------------------
Read : 273
Writes : 0
Fetches: 1,791
Marks : 0
ARTICLES 79
GENERIC_ARTICLES 1
LINK_ART 79
LINK_LA_TYP 79
Query
------------------------------------------------
select distinct
articles.art_id,
articles.art_article_nr,
generic_articles.ga_id,
link_art.la_id,
link_la_typ.lat_sort sort,
link_la_typ.lat_sup_id bra_id,
articles.art_replacement
from link_la_typ
inner join generic_articles on lat_ga_id = ga_id
inner join link_art on lat_la_id = la_id
inner join articles on la_art_id = art_id
where link_la_typ.lat_typ_id=:TYP_ID and link_la_typ.lat_ga_id=:GA_ID
ORDER BY 7 ASC
, 2 ASC
Plan
------------------------------------------------
PLAN SORT (SORT (JOIN (GENERIC_ARTICLES INDEX (GENERIC_ARTICLES_IDX1), LINK_LA_TYP INDEX (LINK_LA_TYP_IDX5), LINK_ART INDEX (LINK_ART_IDX1), ARTICLES INDEX (ARTICLES_IDX1))))
Query Time
------------------------------------------------
Prepare : 16.00 ms
Execute : 3,588.00 ms
Avg fetch time: 170.86 ms
Memory
------------------------------------------------
Current: 18,391,304
Max : 18,452,704
Buffers: 2,048
Operations
------------------------------------------------
Read : 273
Writes : 0
Fetches: 1,791
Marks : 0
ARTICLES 79
GENERIC_ARTICLES 1
LINK_ART 79
LINK_LA_TYP 79