> El 29/07/2015 02:07 p.m., 'Leyne, Sean' [email protected] > [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. Sean
