Use the same database or replicate it for reports and web

Posted by developer on Server Fault See other posts from Server Fault or by developer
Published on 2010-05-19T12:11:47Z Indexed on 2010/05/19 12:20 UTC
Read the original article Hit count: 190

Filed under:

database-performance

I would like to know if i have a web with a huge Database and throw expensive (in time)reports , the best way to do this is with one database for the web and a replicated one for reports, or only one for both, i'm worried that users can throw reports for 5 or more years because they need that information and the web crashes because of this.

Related posts about database-performance

A Perspective on Database Performance Tuning

as seen on SQL Server Central - Search for 'SQL Server Central'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
A Perspective on Database Performance Tuning

as seen on Internet.com - Search for 'Internet.com'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
Will Check Constraints Improve Database Performance?

as seen on SQL Server Performance - Search for 'SQL Server Performance'
[Read Full Article] >>> More
Database Performance Across 3 NetApp FAS2050

as seen on Server Fault - Search for 'Server Fault'
I recently inherited a SQL Server 2005 box that has LUNs mounted on it from three different NetApp FAS2050 filers. The reason there are three is because the first two filers are out of space and our databases continually need more of it. What kind of performance impact (if any) does this setup have… >>> More
Database performance benchmark

as seen on Stack Overflow - Search for 'Stack Overflow'
Any good articles out there comparing Oracle vs SQL Server vs MySql in terms of performance? I'd like to know things like: INSERT performance SELECT performance Scalability under heavy load Based on some real examples in order to gain a better understanding about the different RDBMS. >>> More

Developer IT

Use the same database or replicate it for reports and web - Developer IT

Use the same database or replicate it for reports and web

database-performance

Related posts about database-performance

A Perspective on Database Performance Tuning

A Perspective on Database Performance Tuning

Will Check Constraints Improve Database Performance?

Database Performance Across 3 NetApp FAS2050

Database performance benchmark

Categories cloud