View Single Post
Old 05 Jul 2007, 12:04
moondragon13 moondragon13 is offline
Join Date: Dec 2005
Browsing is fast; posting slow - what size does replicatin make sense?


I am starting to experience a lag (10 seconds or more) in posting on my forum and I believe it could be due to the amount of traffic at a given time that is on the server trying to post messages. Browsing the forum is quick and most pages load in the time it takes to verbally say "1 - 1,000" so about a second to 2 seconds top.

In your experience at what level do you start to see a need to have two databases? One for inserts and the other for the select queries?

I am running MySQL 4.1.20 and will be upgrading to MySQL 5 soon. Will this help?
Reply With Quote