I have an "audit" table (inserts only) that is housed on my Access Backend. We're writing about 15,000 records per day to it. Two questions:
1. Will performance degrade as the table gets bigger?
2. Would moving the table to SQL Server 2008 R2 improve performance?
Thanks for your help, Eddie