Data Sharding or Master and Slaves

"Greg" <[email protected]>
Newsgroups gmane.comp.windows.off-topic
Message-ID <[email protected]>
I am coming in on the tail end of a db optimization plan provided by our software/database vendor. 

The problem: Poor performance on writes and too much data in certain tables which results in poor results, long query times on certain reads. 

The solution: Data Sharding or Master for writes, Slaves for Read and Master Slave replication. 

I am new to both ideas and have been doing research on them this week. Both feel like good ideas but I am not a DBA type; I am a software guy who knows enough to get by on the db side. 

For those that have looked at both as a solution to poor performance and too much data (tables are growing very fast; good news as the business is growing very fast) can you share your experience? Which did you go with and why? 

Also, I have fond what I think are some good links on the subjects though I am interested in any information folks can share with me on this. 

Thanks!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.