Access 97 performance

[Guillermo]

Hi, can anyboydy tell me how access 97 performs within a single
table/form/query environment if the table holds about 21,000,000 (english
millions) rows, 5 columns? no indices, 1 primary key. query on primary key to
return up to a max of 100 rows.no updates.static data. retrieval only.

 

[Rick Brandt]

Hi, can anyboydy tell me how access 97 performs within a single
table/form/query environment if the table holds about 21,000,000
(english millions) rows, 5 columns? no indices, 1 primary key. query
on primary key to return up to a max of 100 rows.no updates.static
data. retrieval only.

Since there actually WILL be an index on the primary key that should perform
reasonably well.

Put another way, if the table is local and the file not unduly fragmented it
should perform about as well as on any other database engine. The primary
factor being disk access speed. If you are having to run that against a
table over a network then it would be quite a bit slower as a 21 million row
index is still a pretty large thing to have to pull over the wire.