Subject RE: [firebird-support] Simple query takes too much time
Author Leyne, Sean
> El 29/07/2015 02:07 p.m., 'Leyne, Sean' Sean@...
> [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

I note that the PK for this table is a BIGINT, is that true for your other tables?

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.