What are the best practices to optimize the application and database for a better performance?

Old forum URL: forums.lhotka.net/forums/t/5432.aspx

somayajulu posted on Friday, September 19, 2008

Generally, performance of an application will go down as and when the database size grows. The application tends to breakdown especially while printing reports.
What are the best practices which you follow to optimize the application and database to ensure a better performance when the database size is huge?

RockfordLhotka replied on Friday, September 19, 2008

If the primary issue is reporting, and its impact on your transactional database, one common solution is to create a reporting database, possibly a data warehouse. Shift your data periodically to this other database and do your reporting from that location.