Subject Slow search on a primary key index
Author Robin Davis

I'm sure this question has been asked a thousand times. If so, I'm sorry.

I have a table of invoices where the primary key is also the invoice
number. I use Access 2003 as the front-end and would like to be able to
search my Firebird 2.0 database by invoice number quickly when asked to
- usually by people questioning their bill! ;-) However, even with a
tiny number like 7000 records to search, it can take over 8 seconds to
find the invoice required. Is there any way I can speed up the searches
so that they are virtually instantaneous, as they are with other
non-primary key indexed fields?

Sorry if this is a stupid question.

Thanks in advance,

Rob Davis