DataBase has grown too large

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a current frontend (where I query the data - and
link to backend) and backend (is where raw data and 3
million records reside) database structure. The backend
db has grown to almost 3 million records and will
continue to grow. I'm looking for suggestions on how to
manage this size and make it as efficient as possible.
Is there a better structure I can use? Any suggestions
are appreciated.
 
We'd need to know more about the structure and purpose of your database.
Personally, I purge some records each year, and move others to a backup
database as they grow old.

Rick B
 
Back
Top