Subject | Re: rdb$procedure_parameters non index read |
---|---|
Author | Dmitry Yemanov |
Post date | 2012-01-10T09:21:03Z |
10.01.2012 11:15, ma_golyo wrote:
overall execution time, it makes a lot of sense to ignore them.
problem is elsewhere.
Dmitry
> Currently the non index read count is over 30K, and this is just a simleSure, but if these non-indexed reads occupy e.g. less than 10% of the
> (few database object) test case.
> Index reads means less record read -> less I/O -> faster execution.
overall execution time, it makes a lot of sense to ignore them.
> Query30K sequential reads cannot last for 12 seconds, so I believe the real
> ------------------------------------------------
> execute procedure dbschema_vc
>
> Query Time
> ------------------------------------------------
> Prepare : 47,00 ms
> Execute : 11 766,00 ms
problem is elsewhere.
Dmitry