Access database with 800,000 records (small ones)
Posted on 2014-07-14
I have a simple database of perhaps 10 tables.
The tables are all small except one (tblBig) which has 10 fields and 800,000 rows.
When I use a form that accesses tblBig all works fine on my personal PC.
However, when my client puts the database on their server it is taking 3 minutes to read ONE record!
The table is indexed on the key field.
How can I make the system faster when reading this table?? Perhaps the solution is on their server and NOT my database??