|Subject||RE: [firebird-support] Simple query takes too much time|
> El 29/07/2015 02:07 p.m., 'Leyne, Sean' Sean@...I note that the PK for this table is a BIGINT, is that true for your other tables?
> [firebird-support] escribió:
> > Jorge:
> >> Using MSAccess, a single query to this table takes an average of 14 ms.
> > You think *14ms* is slow?!?!?!?
> When a similar query over a table with 100000 records takes 1 ms, yes, I think
> it´s slow Note that the timing es for each record (14 ms x 7100 records: 99400
Do the rows in this table undergo a lot of activity which would create record versions? If so, what do the database header page statistics look like? An uncommitted transaction, combined with a lot of updates could result in slow query as the system would need to walk the version list to get the latest version.